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
Στις 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
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
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
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
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
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
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
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
