VACUUM with a small table too much delayed.

From: FBaron(at)co(dot)belcorp(dot)biz
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM with a small table too much delayed.
Date: 2005-04-20 21:26:40
Message-ID: OF739AD13F.2F8619F2-ON05256FE9.006F1A23-05256FE9.0075CC3E@belcorp.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-04-20 23:30:37 Re: VACUUM with a small table too much delayed.
Previous Message Scott Marlowe 2005-04-20 19:58:31 Re: help