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

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

pgsql-admin by date

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

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