From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Eric Lauzon <eric.lauzon@abovesecurity.com>
Cc: stef <stef@ummon.com>
Cc: Richard Huxton <dev@archonet.com>
Subject: Re: Database possible corruption , unsolvable mystery
Date: Wed, 29 Mar 2006 21:14:27 -0800
Message-ID: <200603292114.27866.josh@agliodbs.com> (raw)
In-Reply-To: <F7B73864DD39FA40B6C56B3CE0D4D1CBF007C4@asdc003.abovesecurite.lan>
References: <F7B73864DD39FA40B6C56B3CE0D4D1CBF007C4@asdc003.abovesecurite.lan>
Eric,
> Thank you , this might be a good solution , but we have a bigger upgrade
> comming for 8.1.x later on,
> but considering that other things out of our hands might occur , we
> might seriously look into it after fixing
> the current problems :) [because we dont think that upgrading right now
> will magicly fix the problem we are having.]
It probably won't, but it will prevent a re-occurance before you get around to
the 8.1 upgrade. How much time have you wasted on this issue already, an
issue which might not have occurred if you'd kept up with patch releases? A
patch upgrade is what, 5 minutes of downtime?
> And on about 10 database [all 7.4.6] it is the first time this occur ,
> and the symtom is really on one table, considering
> a few terabytes of data sparsed accros a few db, we might have been
> lucky yet but as of now its the first time
> we can see performance hit only on "delete".
Well, that would be in line with the issues 7.4.7-7.4.12. All of them require
millesecond-timing to hit the bug. You're not likely to see it more than
once.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, eric.lauzon@abovesecurity.com, stef@ummon.com, dev@archonet.com
Subject: Re: Database possible corruption , unsolvable mystery
In-Reply-To: <200603292114.27866.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox