| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | devel(dot)brain99(at)xoxy(dot)net, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Random slow queries |
| Date: | 2016-06-29 21:44:24 |
| Message-ID: | 9890.1467236664@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Jeff Janes <jeff(dot)janes(at)gmail(dot)com> writes:
> On Tue, Jun 28, 2016 at 6:24 PM, <devel(dot)brain99(at)xoxy(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Kristian Schjødt | 2016-06-30 09:36:56 | Re: pg_xlog dir not getting swept |
| Previous Message | Jeff Janes | 2016-06-29 21:30:35 | Re: Random slow queries |