/explore
|
You are here 
|
akorotkov.github.io | ||
| | | | |
www.depesz.com
|
|
| | | | | [AI summary] This post details a PostgreSQL patch introducing faster LIKE and ILIKE index searches using pg_trgm, demonstrating significant performance improvements over sequential scans while discussing the trade-off with increased indexing and maintenance times. | |
| | | | |
www.crunchydata.com
|
|
| | | | | Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve query performance. | |
| | | | |
ottertune.com
|
|
| | | | | We've said it before, we'll say it again: one of the first things you should do, if not the first, when trying to solve a slow-running PostgreSQL query problem is run ANALYZE | |
| | | | |
www.crunchydata.com
|
|
| | | Covering indexes in PostgreSQL are an incredibly helpful feature that can help improve the performance of your application when used correctly. This article demonstrates how an application that collects time-series and geospatial data is able to use covering indexes to boost performance. | ||
