Running 10M PostgreSQL Indexes in Production

Re:Running 10M PostgreSQL Indexes in Production by orf on Tuesday June 13, 2017 @06:24AM (#14543862)

Hey malisper, Have you investigated BRIN[1] indexes? Have you considered or benchmarked those? For naturally ordered data it seems to be pretty efficient.

1. https://www.postgresql.org/docs/9.5/static/brin-intro.html

[ Parent | on HN ]

Re:Running 10M PostgreSQL Indexes in Production by malisper on Tuesday June 13, 2017 @02:56PM (#14547528)

While our data is ordered, a BRIN index doesn't support our use case. We need to perform non-zero amount of deletions/updates to existing data. This leaves holes in our table which will be filled in by new data, which makes a BRIN index unusable since the data is no longer ordered.

[ Parent | on HN ]