Re: pg_attribute always grow...

From: "Patrick Fiche" <patrick(dot)fiche(at)aqsacom(dot)com>
To: "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "PostgreSQL - General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_attribute always grow...
Date: 2002-10-18 07:15:18
Message-ID: 85058ADF852DD5118FD50002A528A5B6079A90@SERVEUR
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Will the same occur if I create real tables instead of temporary tables as
for most of them, there is no concurrent access and no need to have the same
table in two different connexions...
What's the real performance difference between a temporary table and other
tables...

Thanks

Patrick Fiche
email : patrick(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
Sent: Thursday, October 17, 2002 8:58 PM
To: Patrick FICHE
Cc: PostgreSQL - General (E-mail)
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Wright 2002-10-18 10:44:48 Re: PostgreSQL query failed: COPY state must be terminated first
Previous Message Shridhar Daithankar 2002-10-18 06:30:24 Re: Help normalizing table(s)