Re: Random slow queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Random slow queries
Дата
Msg-id 9890.1467236664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Random slow queries  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Jeff Janes <jeff.janes@gmail.com> writes:
> On Tue, Jun 28, 2016 at 6:24 PM,  <devel.brain99@xoxy.net> wrote:
>> PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 64-bit

> The current minor version of that branch is 9.3.13, so you are 9 bug
> fix releases behind.

Definitely a fair complaint.

> I don't know if this matters, because I see that my first guess of
> your problem was fixed in commit 4162a55c77cbb54acb4ac442e, which was
> already included in 9.3.4.

That commit could have helped if the problem were simply slow planning.
But I do not see how it explains a *consistent* 122-second delay.
That sounds very much like a timeout expiring someplace, and I have
no idea where.

            regards, tom lane


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Random slow queries
Следующее
От: Niels Kristian Schjødt
Дата:
Сообщение: Re: pg_xlog dir not getting swept