3 ms·
It does [1]. However I‘m not going to judge the Index count without knowing the exact use case. If it is r/w 95/5 percent, the amount of indices might be ok. If
by chrisandchris 5y ago
It does [1]. However I‘m not going to judge the Index count without knowing the exact use case. If it is r/w 95/5 percent, the amount of indices might be ok. If its 5/95, it‘s obviously not.
[1] https://www.postgresql.org/docs/11/sql-createindex.html https://www.postgresql.org/docs/11/sql-createindex.html
- s3rg4fts 5y agoSadly, in this specific case we update almost 1/10th of the table daily and we have also based our entire searching functionality on indexes in this table. Bad news: our product relies a lot on having so many access patterns so it's hard to limit the indexes at this point Good news: most of the overhead (as you can see from the table with the timings) seems to be caused by the GIN index. We'll most likely move full text search to ElasticSearch and drop this so things will most likely get better. Once the move is done, we'll try dropping indexes and using ElasticSearch more for searches. I've seen this work tremendously well in the past so I have high hopes!