Re: slow growing table

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: slow growing table
Дата
Msg-id 20050606170037.GA1177@uio.no
обсуждение исходный текст
Ответ на slow growing table  (Jone C <jonecster@gmail.com>)
Ответы Re: slow growing table
Список pgsql-performance
On Mon, Jun 06, 2005 at 09:48:26AM -0700, Jone C wrote:
> When the table is new it's very fast, towards the end of the month
> it's taking almost 10 times longer, yet I'm deleting and COPYing in
> the same amount of data.  Other operations on this table slow down,
> too, that were fast before using the same criteria.

You might have a problem with index bloat. Could you try REINDEXing the
indexes on the table and see if that makes a difference?

/* Steinar */
--
Homepage: http://www.sesse.net/

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jone C
Дата:
Сообщение: slow growing table
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: slow growing table