Re: Slow Inserts on large tables

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Slow Inserts on large tables
Дата
Msg-id 48E5D62D.7060400@gmx.net
обсуждение исходный текст
Ответ на Slow Inserts on large tables  ("Peter Childs" <peterachilds@gmail.com>)
Ответы Re: Slow Inserts on large tables  ("Peter Childs" <peterachilds@gmail.com>)
Список pgsql-performance
Peter Childs wrote:
> I have a problem where by an insert on a "large" table will sometimes
> take longer than usual.

> I think the problem might have something to do with checkpoints,

Then show us your checkpointing-related parameters.  Or try to set them
to a lot higher values so checkpoints happen more rarely and see if that
makes a difference.


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

Предыдущее
От: "Peter Childs"
Дата:
Сообщение: Slow Inserts on large tables
Следующее
От: "Peter Childs"
Дата:
Сообщение: Re: Slow Inserts on large tables