public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: [email protected]
Subject: Re: Random slow queries
Date: Mon, 4 Jul 2016 14:19:08 +0200
Message-ID: <CACjsgDmabSJCS4kYJ5-XYsgwhTN4wBhUyrJ4PBt-CMOyxzzZfA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CACjsgDm+n0s=5cMwGF7nRMXS8fX6CF9t1HsOr_M2iejpxKgS1A@mail.gmail.com>
<DM2PR07MB5578DB88C4DCCEA3213FA76DA230@DM2PR07MB557.namprd07.prod.outlook.com>
<CACjsgD=Pg3utmjD8F3ZSYXYnb+2CjuxyDzNbrfwA-_giWGM1sA@mail.gmail.com>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On 29 June 2016 at 22:20, Tom Lane <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Random slow queries
In-Reply-To: <CACjsgDmabSJCS4kYJ5-XYsgwhTN4wBhUyrJ4PBt-CMOyxzzZfA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox