Skip site navigation (1) Skip section navigation (2)

vacuumdb -a -z hangs

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 (view raw or flat)
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



In response to

Responses

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2001-06-06 14:13:26
Subject: psql bug or feature?
Previous:From: Reinoud van LeeuwenDate: 2001-06-06 12:29:25
Subject: Re: ORDER BY Problem...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group