a way of comparing the information to a table?
>
> Chris
>
>> Date: Mon, 14 Sep 2009 09:53:08 -0600
>> Subject: Re: [GENERAL] Locks in postgres causing system load and crash.
>> From: scott.marl...@gmail.com
>> To: compuguruchrisbar...@hotmail.com
>> CC: pgsq
Thanks Scott,
How were you able to determine the resource that was causing it. There must be
a way of comparing the information to a table?
Chris
> Date: Mon, 14 Sep 2009 09:53:08 -0600
> Subject: Re: [GENERAL] Locks in postgres causing system load and crash.
> From: s
On Mon, Sep 14, 2009 at 8:58 AM, Chris Barnes
wrote:
> We have a situation where the database locks escalate and load causes
> problems or the system crashes in some circumstances.
>
> We have munin installed and notice that the locks (access share locks)
> climbed to 2.7k.
>
> I'm wondering what
We have a situation where the database locks escalate and load causes problems
or the system crashes in some circumstances.
We have munin installed and notice that the locks (access share locks) climbed
to 2.7k.
I'm wondering what or how I can get a snapshot of the table(s) and perhaps t
