pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM with a small table too much delayed.
2+ messages / 2 participants
[nested] [flat]
* VACUUM with a small table too much delayed.
@ 2005-04-20 21:26 FBaron@co.belcorp.biz
2005-04-20 23:30 ` Re: VACUUM with a small table too much delayed. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: FBaron@co.belcorp.biz @ 2005-04-20 21:26 UTC (permalink / raw)
To: pgsql-admin
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.
I did the same to a table with 300.000 records and two indexes . and it
finished 20 minutes later.
What can it be happening with the first table?
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.
Thanks for your help.
Fabio Barón S.
DBA, Plataforma Tecnologica
Gerencia Corporativa de Tecnologia
Tel : 4-37-61-61 Ext. 5123
Cel : 311 2-54-74-00
Aviso de confidencialidad:
Este mensaje de correo electrónico contiene información estrictamente
confidencial no susceptible de ser distribuida. Si usted no es el
destinatario de este mensaje, por favor no publicarlo, copiarlo o tomar
cualquier otro tipo de accion sobre esta transmision. Si recibio este
mensaje por error, por favor notifiquenoslo y eliminelo lo antes posible.
Warning of confidentiality:
This message of electronic mail contains strictly confidential information
nonsusceptible to be distributed. If you are not the adressee of this
message, please do not publish it, copy it or take any other kind of action
on this transmission. If you got this message by mistake, please notify it
to us and eliminate it as soon as possible.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: VACUUM with a small table too much delayed.
2005-04-20 21:26 VACUUM with a small table too much delayed. FBaron@co.belcorp.biz
@ 2005-04-20 23:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-04-20 23:30 UTC (permalink / raw)
To: FBaron@co.belcorp.biz; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-20 23:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-20 21:26 VACUUM with a small table too much delayed. FBaron@co.belcorp.biz
2005-04-20 23:30 ` Tom Lane <tgl@sss.pgh.pa.us>
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