Question : I’ve a logging table with approx 1.500.000 rows, the primary key is an ascending identity and the clustered […]
Tag: index-tuning
Searching INET[] for CIDR match, efficiently using indexes (without UNNEST)
Question : This question stems from having recently discovered that the following are very, very different in terms of performance […]
“Inner” Group By Query sequential scan
Question : I have inner-query in left-join that is using sequential scan instead of index scan, and I have no […]
Very slow simple PostgreSQL query on RDS
Question : I seem to be getting very slow queries on a medium sized RDS box (db.m3.medium, 3.7gb ram). This […]
100% index fragmentation
Question : I am hitting database performance issues, so we rebuilt all our indexes as we haven’t been doing a […]
PostgreSQL Index Caching
Question : I’m having difficulty finding ‘lay’ explanations of how indexes are cached in PostgreSQL, so I’d like a reality […]
How can I improve the performance of this query on a table with millions of trigrams?
Question : In an effort to make searching across many string fields in certain tables faster, I’ve been attempting to […]
Any advantage of having a second index with included columns on a primary key?
Question : I’m reviewing our database and noticed that on a particular table we have the following indexes: Table: Col1 […]
Does a re-index update statistics?
Question : I’ve been doing the MS10775A course this past week and one question that came up that the trainer […]
Filter on array text[] and sort on timestamp
Question : Description PostgreSQL 9.6 on Linux, size of tags_tmp table ~ 30 GB (10 million rows), tags is a […]