Re: problems with large table

Поиск
Список
Период
Сортировка
От Mike Charnoky
Тема Re: problems with large table
Дата
Msg-id 46EAA672.8060805@nextbus.com
обсуждение исходный текст
Ответ на Re: problems with large table  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Thanks, recreating the table solved my problems.  Our team is working on
implementing some performance tuning based on other recommendations from
the list (FSM, etc).


Mike

Joshua D. Drake wrote:
> At this point, you are in a world of hurt :). If you stop a vacuum you
> have created a huge mess of dead rows in that table. My suggestion is
> this to create a new table that is populated from the old table, rename
> the old table to big_table new, rename new table to old table. Run analyze.

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Locking entire database
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Documentation fix regarding atan2