VACUUM is hanging

From: Ashley Clark <aclark(at)ghoti(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: VACUUM is hanging
Date: 2001-05-04 14:12:11
Message-ID: 20010504091211.A4403@ghoti.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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, UnUsed 0, 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message armelle clech 2001-05-04 14:14:08 Visual Studio C++
Previous Message Tony Grant 2001-05-04 14:09:15 Re: DB Getting Slower and Slower and Slower....