News for hackers. Stuff that matters.
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';
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 :)