VMware Cloud Community
dgorman_hyperic
Enthusiast
Enthusiast

Postgres 8.2.3 tricks

In case anyone is using PG 8.2.3 with HQ I'd recommend the following:

- setting autovacuum to something with a high-ish cost_delay as even if you have it set to off, there is a built in function that will cause it to run to avoid DB wrap-around

- Check your max_stack_depth if you have more than 200 platforms and increase it so something like 4096
0 Kudos
0 Replies