Re: Proposal: Commit timestamp

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Richard Troy <rtroy(at)sciencetools(dot)com>, Markus Schiltknecht <markus(at)bluegap(dot)ch>, Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>, Theo Schlossnagle <jesus(at)omniti(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, Jim Nasby <decibel(at)decibel(dot)org>
Subject: Re: Proposal: Commit timestamp
Date: 2007-02-08 04:01:31
Message-ID: 45CAA09B.7070204@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/7/2007 10:35 PM, Bruce Momjian wrote:
> I find the term "logical proof of it's correctness" too restrictive. It
> sounds like some formal academic process that really doesn't work well
> for us.

Thank you.

> Also, I saw the trigger patch with no explaination of why it was
> important or who would use it --- that also isn't going to fly well.

You didn't respond to my explanation how the current Slony
implementation could improve and evolve using it. Are you missing
something? I am discussing this very issue with our own QA department,
and thus far, I think I have a majority of "would use a pg_trigger
backpatched PostgreSQL" vs. "No, I prefer a system that knows exactly
how it corrupted my system catalog".

> As far as TOAST, there is no question in my mind that TOAST development
> would happen the same way today as it did when we did it in 2001 --- we
> have a problem, how can we fix it.

Looking at what did happen back then and what happens in this case, I do
see a difference. There were concerns about the compression algorithm
used ... it still is today what was the first incarnation and nobody
ever bothered to even investigate if there could possibly be any better
thing. Do you think lzcompress is the best we can come up with? I don't!
So why is it still the thing used? Maybe it is good enough?

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2007-02-08 04:10:38 Fwd: [webmaster] Its has been a great db experience with pg.
Previous Message Bruce Momjian 2007-02-08 03:57:22 Re: [HACKERS] [PATCHES] [PERFORM] Direct I/O issues