From: | "Andrew Bartley" <abartley(at)evolvosystems(dot)com> |
---|---|
To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, <patrick(dot)fiche(at)aqsacom(dot)com> |
Cc: | "PostgreSQL - General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_attribute always grow... |
Date: | 2002-10-18 03:05:10 |
Message-ID: | 001001c27653$42187f20$3200a8c0@abartleypc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us>
To: <patrick(dot)fiche(at)aqsacom(dot)com>
Cc: "PostgreSQL - General (E-mail)" <pgsql-general(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Bartley | 2002-10-18 03:08:49 | Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory |
Previous Message | Tom Lane | 2002-10-18 01:51:09 | Re: Query performance with small data base |