VACUUM is hanging
От | Ashley Clark |
---|---|
Тема | VACUUM is hanging |
Дата | |
Msg-id | 20010504091211.A4403@ghoti.org обсуждение исходный текст |
Ответы |
Re: VACUUM is hanging
|
Список | pgsql-general |
Maybe someone will know what's going on here. I'm running 7.1 and vacuuming the db regularly at 4am each day. But these last few days as it vacuums it hangs reaping dead processes. 2001-05-04 04:00:09 [27285] DEBUG: --Relation personnel-- 2001-05-04 04:00:09 [27285] DEBUG: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 2001-05-04 04:00:09 [27285] DEBUG: Index personnel_pkey: Pages 1; Tuples 0. CPU 0.00s/0.00u sec. 2001-05-04 04:00:09 [27285] DEBUG: Index personnel_name: Pages 1; Tuples 0. CPU 0.00s/0.00u sec. 2001-05-04 04:00:09 [27285] DEBUG: Index personnel_truck: Pages 1; Tuples 0. CPU 0.00s/0.00u sec. 2001-05-04 04:00:09 [27285] DEBUG: Index personnel_ssn: Pages 1; Tuples 0. CPU 0.00s/0.00u sec. 2001-05-04 04:00:09 [27285] DEBUG: Analyzing... /usr/lib/postgresql/bin/postmaster: reaping dead processes... /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 27299 exited with status 0 /usr/lib/postgresql/bin/postmaster: reaping dead processes... Then there are hundreds of the last three lines until I get here the next morning and try to access the database, that then seems to give it a kick in the pants, for a while at least, then it returns to its inane suicide ritual. Any ideas? Restarting the DB and running a vacuum by hand in psql works, but I don't know if it will clog up tonight or not... -- really hacks
Вложения
В списке pgsql-general по дате отправления: