Alvaro,
> Are you really using vacuum_cost_delay=2000? If so, therein lies your
> problem. That's a silly value to use for that variable. Useful values
> are in the 20-40 range probably, or maybe 10-100 being extremely
> generous.
Thank you.
My 8.1.4 postgresql.conf does not contain such option. So vacuum_cost_delay
is off probably.
Since doc does not recommend any value, I planned to use 2000
Will value of 30 allow other clients to work when VACUUM FULL is running ?
Uncommented relevant values in postgresql.conf file are:
shared_buffers = 15000
work_mem = 512
maintenance_work_mem = 131072
fsync = on
effective_cache_size= 70000
log_min_duration_statement= 30000
Andrus.
