undefined | Better HN

0 pointsbtilly10y ago0 comments

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.

0 comments

You 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.

j / k navigate · click thread line to collapse

0 pointsbtilly10y ago0 comments

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.

You 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.

j / k navigate · click thread line to collapse