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

From: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: hubert depesz lubaczewski <depesz(at)depesz(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Huge spikes in number of connections doing "PARSE"
Date: 2011-03-12 00:16:00
Message-ID: AANLkTi=DUxGjSizQMiGR-vp7zufMiRnFH5n2C+zz=rDC@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 11, 2011 at 11:13 AM, Noah Misch <noah(at)leadboat(dot)com> wrote:

>
> gdb -ex=bt /path/to/bin/postgres $pid </dev/null
>
> I've used this on production systems to debug issues like this one, and
> I've
> never observed damage. The exact effect of debugger attach/detach may be
> OS/kernel-dependent, so it's hard to make categorical guarantees of safety.

At least on Windows NT and derivatives (until I last checked a few years
ago), detaching a debugger kills the debugged process.

Regards,
--
Gurjeet Singh
EnterpriseDB <http://www.enterprisedb.com/> Corporation
The Enterprise PostgreSQL <http://www.postgresql.org/> Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jov 2011-03-12 04:29:48 Re: how can I get back superuser back?
Previous Message runner 2011-03-11 23:09:40 Re: How do you change the size of the WAL files?