Re: Strange deadlock error last night

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Scott Whitney" <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Strange deadlock error last night
Date: 2009-01-13 22:50:39
Message-ID: dcc563d10901131450m72c01387y11db04359cbdcfdf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jan 13, 2009 at 3:35 PM, Scott Whitney <swhitney(at)journyx(dot)com> wrote:
> Thanks for all the information, guys. I think Tom was right. Our application
> was doing a couple of full vacs at the same time. It's weird that we didn't
> run into this in the past.
>
> You're all absolutely right about the upgrading, but in our environment,
> it's not 2-3 minutes. It's 2-3 weeks. I've got to fully vet the app on the
> platform internally with full test plans, etc, even for the most minor
> upgrades; corp policy.

That's preparation time versus execution time. While it may take 2-3
weeks to get the testing done, once done, the actual down time is
minimal. I would suggest that your current testing methodology is
horribly flawed. I know it was foisted on you by outside forces, so
it's not really "your" idea. But you know what I mean. There's the
cost of possible data loss / down time due to unforseen problems
caused by an update, and there's the cost of possible data loss / down
time due to known flaws in your current code. If your testing
methodology was strict enough, it would have found such flaws that
were fixed in subsequent releases, but it hasn't. Meantime, you spend
weeks testing for possible new bugs, while running known broken code
with real data loss / down time inducing bugs.

There's a reasonable cost / benefits analysis, and right now,
someone's set the cost far too high for far too few benefits. Been
where you are, and I know how much it sucks.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message dx k9 2009-01-14 00:08:31 initdb
Previous Message Scott Whitney 2009-01-13 22:35:12 Re: Strange deadlock error last night