2 votes

Postgres BRIN index for time-series table

A BRIN index serves the same purpose as a B-tree index (only it is much smaller and less efficient for searches), so there is never a point in having both on the same column. Just don't create the ...
Laurenz Albe's user avatar
  • 51.6k
1 vote

Efficient Pagination In Postgresql (Keyset Pagination)

There are three key things you need to be able to use Keyset Pagination successfully. An ORDER BY on a unique set of columns. On subsequent pages, a WHERE clause on the same set of columns, ...
Charlieface's user avatar
  • 12.8k

Only top scored, non community-wiki answers of a minimum length are eligible