On Thu, Jan 19, 2006 at 10:35:30AM -0800, David Scott wrote: > Tom Lane wrote: > > >What sort of problems are you dealing with exactly? There has been > >some discussion of changes that would improve certain scenarios. For > >instance it might be plausible to do joins using index information and > >only go back to the heap for entries that appear to pass the join test.
Do you still have that patch that folks could look at? ISTM that this technique would be rather dependant on your actual workload, and as such could result in a big win for certain types of queries. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
