From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: row wise comparison broken |
Date: | 2004-09-10 15:01:05 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A74A3@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Yes, I found the following thread started by you in the
> pgsql-performance list:
>
> Subject: [PERFORM] best way to fetch next/prev record based on index
> Date: Tue, 27 Jul 2004 06:18:43 -0700
>
> > there were some concerns about backwards compatibility.
>
> IMO 8.0 is a good chance to fix it. Maybe we could add a GUC switch to
> fall back to pre-8.0 behavior...
> --
> Tatsuo Ishii
Here is a link to Tom's thoughts on possible approaches to implementing
a fix, and why this is A Lot More Complicated Than It Seems (tm),
particularly if taken to the next logical step where the planner could
make use of the row-wise comparison to make more intelligent decisions
about index selection.
http://archives.postgresql.org/pgsql-performance/2004-07/msg00218.php
Still, I think the current behavior is wrong...and is exactly the kind
of trick question that a sql compliance benchmark might ask.
Merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Grant Finnemore | 2004-09-10 15:05:17 | Re: Failed assertion, CVS head |
Previous Message | Andrew Dunstan | 2004-09-10 14:54:44 | Re: APR 1.0 released |