Patrick Fiche wrote:
> 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 ?
Yes, it could very well be that. I am quite embarassed by our need to
reindex.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073