Eric Ridge kirjutas R, 09.01.2004 kell 01:16: > Forgetting about composite indexes for a moment, is postgres even > capable of doing 2 index scans in this situation? Does it know how do > take the intersection of two scans?
Not currently, but it has been in TODO for quite some time: * Use bitmaps to fetch heap pages in sequential order [performance] * Use bitmaps to combine existing indexes [performance] --------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]