News for hackers. Stuff that matters.

A comment on Index bloat reduced in PostgreSQL v14. Parent comment

Re:Index bloat reduced in PostgreSQL v14 by whoknowswhat11 on Saturday September 11, 2021 @06:21AM (#28490782)
Aurora PostgreSQL has something called Query Plan Management - which I like - is meant to address this type of issue especially for large tables that have key queries that you could blow up DB basically if they go haywire in planning.

Would def be a feature that would be nice to see in PostgreSQL itself.

[ Parent | on HN ]
Re:Index bloat reduced in PostgreSQL v14 by cutemonster on Saturday September 11, 2021 @09:05AM (#28491661)
It'd be nice if one could tell pg to only change its query plans during certain change windows, say, the first Saturday each month, with on call staff ready.

And if there was a "Revert to o old plans" button

[ Parent | on HN ]