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)
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 database, and
brought the website down due to enor
