Re: pg_attribute always grow...

I am having the same problems.

I too do a lot of creation and dropping of temp tables from within
functions.

Should I reindex every night?


----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: <patrick.fiche@aqsacom.com>
Cc: "PostgreSQL - General (E-mail)" <pgsql-general@postgresql.org>
Sent: Friday, October 18, 2002 4:58 AM
Subject: Re: [GENERAL] pg_attribute always grow...


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>