News for hackers. Stuff that matters.

A comment on Running 10M PostgreSQL Indexes in Production. Parent comment

Re:Running 10M PostgreSQL Indexes in Production by artumi-richard on Tuesday June 13, 2017 @08:41AM (#14544301)
I would have thought a single multi-column index would have been more appropriate. Did you consider these? They have been in PostgreSQL since 9.2

https://www.postgresql.org/docs/9.2/static/indexes-multicolu...

[ Parent | on HN ]
Re:Running 10M PostgreSQL Indexes in Production by malisper on Tuesday June 13, 2017 @02:52PM (#14547500)
A single multi-column index would only work for the one specific query in the example. We have many queries that contain filters that are not easy to index such as regular expression filters. Additionally, a multi-column index would be significantly larger than the corresponding partial index.
[ Parent | on HN ]