Postgres Indexing: When Does BRIN Win?

Re:Postgres Indexing: When Does BRIN Win? by aspyct on Thursday July 14, 2022 @07:35AM (#32094582)

I don't delete anything in those tables, however I do one update on 9/10 of the rows, at least.

I seem to remember there was a way to reorder rows in a table, maybe that could be useful.

[ Parent | on HN ]

Re:Postgres Indexing: When Does BRIN Win? by pramsey on Thursday July 14, 2022 @11:59AM (#32097750)

You can check if your data remain correlated after your updates. It's possible they do: SELECT correlation FROM pg_stats WHERE tablename = 'mytable' AND attname = 'mytimestamp';

[ Parent | on HN ]

Re:Postgres Indexing: When Does BRIN Win? by aspyct on Friday July 15, 2022 @04:04AM (#32105865)

Oh nice! I had no idea, I'll try it, thanks :)

[ Parent | on HN ]