pg_attribute always grow... - Mailing list pgsql-general

From Patrick Fiche
Subject pg_attribute always grow...
Date
Msg-id 85058ADF852DD5118FD50002A528A5B6079A8F@SERVEUR
Whole thread Raw
Responses Re: pg_attribute always grow...  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Is there any reason why pg_attribute could always grow ( size in
relpages... ) even if number of tuples don't grow...
The indexes pg_attribute_relid_attnam_index and
pg_attribute_relid_attnum_index grow and I don't see any way to vacuum them
without restarting postgres with -O and -P options and launching REINDEX
command.
Could it be due to the fact that I create and drop many temporary tables in
stored procedures ?
Please help!!!!

Thanks

Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18



pgsql-general by date:

Previous
From: Shane Wright
Date:
Subject: PostgreSQL query failed: COPY state must be terminated first
Next
From: Jeff Eckermann
Date:
Subject: Re: PostgreSQL query failed: COPY state must be terminated first