Re: explain analyze reports that my queries are fast but they run very slowly

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: explain analyze reports that my queries are fast but they run very slowly
Дата
Msg-id CAPmjWd2PTkOfRLFyQ0tfp0dXUb3_GfQO9T2U0m95ejA4sw5LHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: explain analyze reports that my queries are fast but they run very slowly  (Nikolas Everett <nik9000@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Actually that last paragraph doesn't make much sense.  Please ignore it.


On Thu, Dec 27, 2012 at 12:58 PM, Nikolas Everett <nik9000@gmail.com> wrote:
New news - the hot slave seems to be performing as expected with no long pauses.

It looks like we're using an archive_timeout of 60 seconds and default checkout_timeout and checkpoint_completion_target.  I didn't do any of the research on this.  It seems like we're asking postgres to clear all of the dirty buffers every 60 seconds.  With 48 gigs of shared buffers we could have quite a few buffers to clear.  Is there some place I could check on how all that is going?

On Thu, Dec 27, 2012 at 12:45 PM, Nikolas Everett <nik9000@gmail.com> wrote:
p


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

Предыдущее
От: Nikolas Everett
Дата:
Сообщение: Re: explain analyze reports that my queries are fast but they run very slowly
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Why does the query planner use two full indexes, when a dedicated partial index exists?