Re: Huge spikes in number of connections doing "PARSE"

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Huge spikes in number of connections doing "PARSE"
Date: 2011-03-11 23:04:30
Message-ID: 20110311230430.GA19621@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 11, 2011 at 11:13:43AM -0500, Noah Misch wrote:
> gdb -ex=bt /path/to/bin/postgres $pid </dev/null

thanks. added cronjob that will get stacktrace of random 10 backend in
parse state, when we'll have more than 100 of them.

It will take some time to gather some more evidence though.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message runner 2011-03-11 23:09:40 Re: How do you change the size of the WAL files?
Previous Message Andrew Sullivan 2011-03-11 22:02:17 Re: How do you change the size of the WAL files?