Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id 1112050751.11750.924.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Delete query takes exorbitant amount of time  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Fri, 2005-03-25 at 09:38 -0800, Josh Berkus wrote:
> > I guess I was wondering if there is other general tuning advice for such
> > large table indexes such as increasing statistics, etc.
>

> If you're going with the drop/load/recreate option, then I'd suggest
> increasing work_mem for the duration.  Hmmm ... or maintenance_work_mem?
> What gets used for FK checks?  Simon?
>

In 8.0, maintenance_work_mem is used for index creation, vacuum and
initial check of FK checks at time of creation. Everything else uses
work_mem as the limit.

Best Regards, Simon Riggs




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

Предыдущее
От: "Dave Held"
Дата:
Сообщение: JDBC best practice
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?