40 ms·
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. h
by orf 9y ago
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 https://www.postgresql.org/docs/9.5/static/brin-intro.html
- malisper 9y agoWhile 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.