On Wed, May 10, 2006 at 09:47:07AM -0500, Dave Dutcher wrote: > The hash lines mean your tables are being joined by hash joins. You > should read this page for more info: > > http://www.postgresql.org/docs/8.1/interactive/performance-tips.html <tooting-own-horn>You might also want to read http://www.pervasivepostgres.com/instantkb13/article.aspx?id=10120&query=explain -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461