Re: Random performance hit, unknown cause.

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Random performance hit, unknown cause.
Дата
Msg-id CAGTBQpb-jBxksVQ4MFjjSELY2428zNkgTZXLqrj+QmezFzA4MA@mail.gmail.com
обсуждение исходный текст
Ответ на Random performance hit, unknown cause.  (Brian Fehrle <brianf@consistentstate.com>)
Список pgsql-performance
On Thu, Apr 12, 2012 at 3:41 PM, Brian Fehrle
<brianf@consistentstate.com> wrote:
> Is there anything that can help us maximise the performance to disk in this
> case, as it seems to be one of our major bottlenecks?

If it's indeed autovacuum, like I think it is, you can try limiting it
with pg's autovacuum_cost_delay params.

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Random performance hit, unknown cause.
Следующее
От: Brian Fehrle
Дата:
Сообщение: Re: Random performance hit, unknown cause.