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
Στις 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, running
On Tue, Apr 14, 2009 at 12:25 AM, Bryce Nesbitt bry...@obviously.com 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,
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
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
Date: Mon, 13 Apr 2009 17:09:49 -0400
From: Glenn Maynard glennfmayn...@gmail.com
To: pgsql-sql@postgresql.org
Subject: Re: changing multiple pk's in one update
Message-ID: d18085b50904131409g10d43d6cs35dd14ede13b...@mail.gmail.com
(JMdict? I was playing with importing that into a DB a 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
On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt bry...@obviously.com 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
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