Postgres Pro
Downloads
Home   >   mailing lists

Vacuum error - Mailing list pgsql-admin

From Hernandez Alvarez Alfredo
Subject Vacuum error
Date
Msg-id Pine.SGI.4.10.10009290947340.29558-100000@hafnio.servidores.unam.mx
Whole thread Raw
List pgsql-admin
Tree view 


    Hi. I'm having the following error when i try to vacuum a table:

horde=# vacuum verbose analyze active_sessions;
NOTICE:  --Relation active_sessions--
NOTICE:  Pages 144114: Changed 1, reaped 144113, Empty 0, New 0; Tup 3078:
Vac 564305, Keep/VTL 0/0, Crash 0, UnUsed 1046335, MinLen 166, MaxLen
2174; Re-using: Free/Avail. Space 1171699388/1171699388; EndEmpty/Avail.
Pages 0/144113. CPU 19.53s/6.35u sec.
NOTICE:  Index active_sessions_pkey: Pages 574; Tuples 3078: Deleted
5827. CPU 0.21s/0.37u sec.
ERROR:  No one parent tuple was found


    Could anyone help me to figure out what is wrong, please???


    thanks in advance



    Ajha

pgsql-admin by date:

Previous
From: "Anthony E . Greene"
Date:
Subject: Re: PostgresQL Connection Question
Next
From: "Vladimir V. Zolotych"
Date:
Subject: postgres functions(.so)