MIME-Version: 1.0
In-Reply-To: <29847.1467231631@sss.pgh.pa.us>
References: 
 <CACjsgDm+n0s=5cMwGF7nRMXS8fX6CF9t1HsOr_M2iejpxKgS1A@mail.gmail.com>
 <DM2PR07MB5578DB88C4DCCEA3213FA76DA230@DM2PR07MB557.namprd07.prod.outlook.com>
 <CACjsgD=Pg3utmjD8F3ZSYXYnb+2CjuxyDzNbrfwA-_giWGM1sA@mail.gmail.com>
 <29847.1467231631@sss.pgh.pa.us>
From: devel.brain99@xoxy.net
Date: Mon, 4 Jul 2016 14:19:08 +0200
Message-ID: 
 <CACjsgDmabSJCS4kYJ5-XYsgwhTN4wBhUyrJ4PBt-CMOyxzzZfA@mail.gmail.com>
Subject: Re: Random slow queries
To: pgsql-performance@postgresql.org
Content-Type: text/plain; charset=UTF-8
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 29 June 2016 at 22:20, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Don't know if it would be practical for you at all, but if you could
> attach to a process that's stuck like this with a debugger and get a stack
> trace, that would probably be very informative.

It seems I have found the cause of my issues: my antivirus software.
When I tried to debug a stuck process, the currently executing code was in
some DLL without debugging information etc. When checking where the DLL came
from, it appeared to be from the security software I had installed.

I had been meaning to change because I have had some performance issues in
the past (nowhere near as bad as this issue though!) but hadn't yet gotten
around to it. After switching this weekend, the issue went away completely.

Even though I had previously noticed some performance issues with my
antivirus, I must say this still is a very weird failure mode - especially
as it still occurred if I disabled all realtime protection (one of the
first things I tried, even if not mentioned in my earlier emails).

Thanks for the time spent trying to help!

Best regards,
Roel


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance