Every so often our production Postgres 8.3 system will get statement
that runs for a few hours, or a few days, or more, and needs to be
killed dead. We kill it with pg_cancel_backend(), and cpu usage of the
process immediately drops, and the process starts serving other
statements. But the curio
On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt wrote:
> Scott Marlowe wrote:
>>
>> What does pg_locks say during this time? Specifically about locks
>> that aren't granted?
>
> I don't know, yet. Though these events go for 15-30 minutes before postgres
> restart, and no deadlocks are detected, s
Scott Marlowe wrote:
What does pg_locks say during this time? Specifically about locks
that aren't granted?
I don't know, yet. Though these events go for 15-30 minutes before
postgres restart, and no deadlocks are detected, so I don't think it is
locks.
--
Sent via pgsql-sql mailing list (p
Date: Mon, 13 Apr 2009 17:09:49 -0400
From: Glenn Maynard
To: pgsql-sql@postgresql.org
Subject: Re: changing multiple pk's in one update
Message-ID:
(JMdict? I was playing with importing that into a DB a while back,
but the attributes in that XML are such a pain--and then my email died
while
Thanks for the thoughts on what to check. Unfortunately, the priority
of the people responding to the incidents has been to get the system
live again. I will add these items to a list that, hopefully, will be
run through prior to restarting Postgres.
Achilleas Mantzios wrote:
Did you check
Dirk Jagdmann wrote:
When you need to choose between enum types, domain types or lookup tables
with foreign keys, what do you usualy choose?
When I have a column with valid values that I know when writing my
tables and that will *never* change I use an enum. For example a human
gender type (and
On Tue, Apr 14, 2009 at 12:25 AM, Bryce Nesbitt wrote:
> We have a medium scale installation of Postgres 8.3 that is freezing about
> once a week. I'm looking for any hints on how to diagnose the situation, as
> nothing is logged.
>
> The system is matched pair of Sunfire servers, running Debian
Στις Tuesday 14 April 2009 09:25:54 ο/η Bryce Nesbitt έγραψε:
> We have a medium scale installation of Postgres 8.3 that is freezing
> about once a week. I'm looking for any hints on how to diagnose the
> situation, as nothing is logged.
>
> The system is matched pair of Sunfire servers, runnin
We have a medium scale installation of Postgres 8.3 that is freezing
about once a week. I'm looking for any hints on how to diagnose the
situation, as nothing is logged.
The system is matched pair of Sunfire servers, running Debian Etch with
a 2.6.18-6-amd64 kernel, PostgreSQL 8.3.4, and DRBD