top | item 43366298

(no title)

marsavar | 11 months ago

That's amazing! Could you elaborate more on your VACUUM planning?

discuss

order

Eikon|11 months ago

Mostly, be careful with long-running transactions (hours long), and modify your autovacuum settings to be as aggressive as possible based on your workload. Be careful with the freezing threshold too.

I ran into

    multixact "members" limit exceeded
Quite a bit when starting out :)

whitepoplar|11 months ago

Can you recommend a good rule of thumb for autovacuum settings given a large workload like yours?