hubert depesz lubaczewski wrote:
> 1. postgresql 8.2.4
> 2. system is 8-way xeon, 64bit with 32gram.
> 3. autovacuum is (and was) turned off in configuration.
> 4. today in peak hours autovacuum started. no mention of it in logs. it
> just showed. started to vacuum the largest table in main databas
sorry to bother you. problem has been found, it's the (default, too low)
value of autovacuum_freeze_max_age.
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
