=?iso-8859-15?q?Herv=E9=20Piedvache?= <[EMAIL PROTECTED]> writes:
> and I have also saw that the full vacuum for pg_atribute seems 
> to be so slow ... more than 1 min for 7256 tupples ? Is this is normal ?

> INFO:  --Relation pg_catalog.pg_attribute--
> INFO:  Pages 119: Changed 0, reaped 1, Empty 0, New 0; Tup 7256: Vac 0, Keep/
> VTL 0/0, UnUsed 3, MinLen 128, MaxLen 128; Re-using: Free/Avail. Space 
> 14664/504; EndEmpty/Avail. Pages 0/1.
>         CPU 0.00s/0.00u sec elapsed 0.08 sec.
> INFO:  Index pg_attribute_relid_attnam_index: Pages 21082; Tuples 7256: 
> Deleted 0.
>         CPU 0.83s/0.13u sec elapsed 59.32 sec.
> INFO:  Index pg_attribute_relid_attnum_index: Pages 5147; Tuples 7256: Deleted 
> 0.
>         CPU 0.26s/0.03u sec elapsed 8.79 sec.

You're suffering from index bloat (21000 pages in an index for a
119-page table!?).  Updating to 7.4 would probably fix this, but
if that's not practical consider reindexing pg_attribute.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to