> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
