Re: [GENERAL] Manual Vaccum very slow with Autovaccum enabled

2007-07-31 Thread Gregory Stark
"Andy Dale" <[EMAIL PROTECTED]> writes: > Hi, > > I am working with a 3 Postgresql databases, 1 is configured with autovaccum > enabled with the following settings: > > vacuum_cost_delay = 200 # 0-1000 milliseconds > vacuum_cost_limit = 100 # 0-1 credits ... >

[GENERAL] Manual Vaccum very slow with Autovaccum enabled

2007-07-31 Thread Andy Dale
Hi, I am working with a 3 Postgresql databases, 1 is configured with autovaccum enabled with the following settings: vacuum_cost_delay = 200 # 0-1000 milliseconds vacuum_cost_page_hit = 6# 0-1 credits #vacuum_cost_page_miss = 10 # 0-1 credits #vacuu