K C Lau wrote:
I'm wondering if this performance issue is common enough for other users to merit a fix in pg, especially as it seems that with MVCC, each of the data records need to be accessed in addition to scanning the index.
Yes - there are certainly cases where index only access (or something similar, like b+tree tables) would be highly desirable.
From what I have understood from previous discussions, there are difficulties involved with producing a design that does not cause new problems...
regards Mark ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly