Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Tue, Sep 07, 2004 at 07:58:56PM -0400, Doug McNaught wrote:
>> Hard to say how it would work, but come up with a good design and >> quality patch and it'll probably go in. :) > > Probably not. This has been discussed before; what's needed is that the > visibility information is stored also in the index. This is hard and > inefficient to do, because it requires updating the index at the same > time that the heap is updated. Which is a bad proposition as soon as > there is more than one index, and when there is a seqscan involved (i.e. > no index), because it means a lot of extra I/O. Yeah, hence the smiley. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])