From: Tom Lane <tgl@sss.pgh.pa.us>
To: FBaron@co.belcorp.biz
Cc: pgsql-admin@postgresql.org
Subject: Re: VACUUM with a small table too much delayed.
Date: Wed, 20 Apr 2005 19:30:37 -0400
Message-ID: <2119.1114039837@sss.pgh.pa.us> (raw)
In-Reply-To: <OF739AD13F.2F8619F2-ON05256FE9.006F1A23-05256FE9.0075CC3E@belcorp.biz>
References: <OF739AD13F.2F8619F2-ON05256FE9.006F1A23-05256FE9.0075CC3E@belcorp.biz>
FBaron@co.belcorp.biz writes:
> Hi, I'm running a vaccum process to a table with 1427 records and three
> indexes with the same size. This process is running 6 hours ago and does
> not finish, I had to kill it.
Was it actually *doing* anything, or just sitting? Perhaps it was
waiting for some other process's lock.
> This is the VACUUM message after cancel
> INFO: --Relation public.unical_ejitem--
> INFO: Pages 416: Changed 0, reaped 396, Empty 0, New 0; Tup 1427: Vac
> 20993, Keep/VTL 0/0, UnUsed 0, MinLen 130, MaxLen 150; Re-using:
> Free/Avail. Space 3102472/3101520; EndEmpty/Avail. Pages 0/397.
> CPU 0.02s/0.00u sec elapsed 3.48 sec.
Hmm ... VACUUM hasn't printed messages that looked like that since 7.3
... you might want to think about an update sometime.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, FBaron@co.belcorp.biz
Subject: Re: VACUUM with a small table too much delayed.
In-Reply-To: <2119.1114039837@sss.pgh.pa.us>
References: <OF739AD13F.2F8619F2-ON05256FE9.006F1A23-05256FE9.0075CC3E@belcorp.biz> <2119.1114039837@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox