From: | "Patrick Fiche" <patrick(dot)fiche(at)aqsacom(dot)com> |
---|---|
To: | "'PostgreSQL - General (E-mail)'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_attribute always grow... |
Date: | 2002-10-21 09:58:56 |
Message-ID: | 85058ADF852DD5118FD50002A528A5B6079A94@SERVEUR |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there any plan in the near future to change this ?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
Sent: Friday, October 18, 2002 5:42 PM
To: Patrick FICHE
Cc: PostgreSQL - General (E-mail)
Subject: Re: [GENERAL] pg_attribute always grow...
Sorry, real and temporary tables are going to have the same problems.
---------------------------------------------------------------------------
Patrick Fiche wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Ivanov | 2002-10-21 10:23:30 | Re: creating a new type in C |
Previous Message | mk | 2002-10-21 08:27:29 | Re: referential integrity violation |