| From: | "Magnus Naeslund\(f\)" <mag(at)fbab(dot)net> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | vacuumdb -a -z hangs |
| Date: | 2001-06-06 13:59:13 |
| Message-ID: | 00b601c0ee90$de7b7cb0$020a0a0a@totalmef |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I have a cronjob that does a vacuumdb -a -z every night.
When i came to work this morning i saw a lot of postgres processes hanging
on wait.
The last thing i see before it hangs is this:
-------------------------------------------------------------
NOTICE: --Relation pg_toast_1216--
NOTICE: 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.
NOTICE: Index pg_toast_1216_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
-------------------------------------------------------------
is this a known problem?
Postgres is version 7.1.1.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Programmer/Networker [|] Magnus Naeslund
PGP Key: http://www.genline.nu/mag_pgp.txt
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2001-06-06 14:13:26 | psql bug or feature? |
| Previous Message | Reinoud van Leeuwen | 2001-06-06 12:29:25 | Re: ORDER BY Problem... |