Re: pg_attribute always grow...
От | Patrick Fiche |
---|---|
Тема | Re: pg_attribute always grow... |
Дата | |
Msg-id | 85058ADF852DD5118FD50002A528A5B6079A90@SERVEUR обсуждение исходный текст |
Ответ на | pg_attribute always grow... ("Patrick Fiche" <patrick.fiche@aqsacom.com>) |
Ответы |
Re: pg_attribute always grow...
|
Список | 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.fiche@aqsacom.com tél : 01 69 29 36 18 -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.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@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
В списке pgsql-general по дате отправления: