Re: pg_attribute always grow...
От | Andrew Bartley |
---|---|
Тема | Re: pg_attribute always grow... |
Дата | |
Msg-id | 001001c27653$42187f20$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | Re: pg_attribute always grow... (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | 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@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 > >
В списке pgsql-general по дате отправления: