May 2018
Intermediate to advanced
576 pages
30h 25m
English
If you have a huge table and a query to select only a subset of that table, then you may wish to use a BRIN index (block range index). These give performance improvements when the data is naturally ordered as it is added to the table, such as logtime columns or a naturally ascending OrderId column. Adding a BRIN index is fast and very easy and works well for the use case of time series data logging, though less well under intensive updates. An INSERTs into BRIN indexes are specifically designed to not slow down as the table gets bigger, so they perform much better than btree indexes.
You may also think that you need to manually partition a table. This can involve significant effort to set up an effective partitioning ...