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 adeel_siddiqui on Saturday September 11, 2021 @05:27AM (#28490605)
set `enable_seqscan` = 'off' or set local `enable_seqscan` = 'off'. This will force the pg query planner to use indexes. Experiment with it until you figure out why your query performance deteriorates. Maybe you are doing a lot of updates/deletes? Increase the statistics sampling size? Autovacuum more frequently?
[ Parent | on HN ]
Re:Index bloat reduced in PostgreSQL v14 by silon42 on Saturday September 11, 2021 @04:19PM (#28495525)
Could one disable statistics completely? Personally, I'd prefer to specify the execution plan manually.
[ Parent | on HN ]