| From: | Hernandez Alvarez Alfredo <ahernand(at)hafnio(dot)servidores(dot)unam(dot)mx> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Vacuum error |
| Date: | 2000-09-29 14:47:58 |
| Message-ID: | Pine.SGI.4.10.10009290947340.29558-100000@hafnio.servidores.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir V. Zolotych | 2000-09-30 08:27:48 | postgres functions(.so) |
| Previous Message | Anthony E . Greene | 2000-09-27 12:21:51 | Re: PostgresQL Connection Question |