From: Guillaume Cottenceau <gc@mnc.ch>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: planner with index scan cost way off actual cost,
Date: 22 Mar 2006 17:25:56 +0100
Message-ID: <87irq6e99n.fsf@meuh.mnc.lan> (raw)
In-Reply-To: <1143044174.17999.7.camel@state.g2switchworks.com>
References: <87ek11gz69.fsf@meuh.mnc.lan>
<441CDAAA.20609@paradise.net.nz>
<87d5ghms3h.fsf@meuh.mnc.lan>
<20060321095049.GW15742@pervasive.com>
<441FD82D.1040509@paradise.net.nz>
<20060321115100.GM15742@pervasive.com>
<87acbkkl0o.fsf@meuh.mnc.lan>
<20060321174903.GG15742@pervasive.com>
<87slpaj46q.fsf@meuh.mnc.lan>
<1143044174.17999.7.camel@state.g2switchworks.com>
Hi Scott,
Scott Marlowe <smarlowe 'at' g2switchworks.com> writes:
> On Wed, 2006-03-22 at 02:04, Guillaume Cottenceau wrote:
[...]
> > Yes, we use 7.4.5 actually, because "it just works", so production
> > wants to first deal with all the things that don't work before
> > upgrading. I have recently discovered about the background writer
> > of 8.x which could be a supplementary reason to push for an
> > ugprade though.
>
> Imagine you get a call from the manufacturer of your car. There's a
> problem with the fuel pump, and, in a small percentage of accidents,
> your car could catch fire and kill everyone inside.
>
> Do you go in for the recall, or ignore it because you just want your car
> to "just work?"
Ah, this holy computer/OS/whatever-to-cars comparison.. How many
million electrons would the world save if computer people would
abandon it? :)
> In the case of the third number in postgresql releases, that's what
> you're talking about. the updates that have come after the 7.4.5
> version, just talking 7.4 series here, have included a few crash and
> data loss fixes. Rare, but possible.
I guess we didn't know that. I for myself have (a bit more)
excuses because I'm on the development side :) But I've passed
the information to the operation team, thank you.
--
Guillaume Cottenceau
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: gc@mnc.ch, smarlowe@g2switchworks.com
Subject: Re: planner with index scan cost way off actual cost,
In-Reply-To: <87irq6e99n.fsf@meuh.mnc.lan>
* 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