Re: locking issue on simple selects?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: locking issue on simple selects?
Дата
Msg-id 4C9B935D0200002500035C76@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: locking issue on simple selects?  (Tobias Brox <tobixen@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Tobias Brox <tobixen@gmail.com> wrote:

> 13:19:13.840 - LOG: checkpoint complete

> 13:19:13.841 - LOG:  checkpoint starting

> 13:20:43.176 - LOG:  checkpoint complete

There wasn't a lot of time between the completion of one checkpoint
and the start of the next.  And the two checkpoints finished a
minute and a half apart.  Perhaps you need to boost your
checkpoint_segments setting?  What is it now?

-Kevin

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

Предыдущее
От: Tobias Brox
Дата:
Сообщение: Re: locking issue on simple selects?
Следующее
От: adrian.kitchingman@dse.vic.gov.au
Дата:
Сообщение: postgresql-9.0 Windows service stops after database transaction