2 ms·
The first thing that I tried was a full VACUUM ANALYZE and then re-ran the same query. It didn't help. Therefore modifying autovacuum won't help. Adjusting i
by btilly 11y ago
The first thing that I tried was a full VACUUM ANALYZE and then re-ran the same query. It didn't help. Therefore modifying autovacuum won't help.
Adjusting internal costs is promising, but I'd like to avoid going there exactly because of the possible negative side effects that you mention.
- Jweb_Guru 11y agoYou can adjust the costs on a per-session (or even per-transaction) basis. Depending on the nature of your query, it might be worth it.