> -----Original Message----- > From: pgsql-performance-owner@xxxxxxxxxxxxxx > [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane > > [ fools around with it for awhile... ] I think this is already fixed > for 8.2.1. Note the costs of the two related index scans: I installed 8.2.1 this morning and it works much better. The query that was taking 3411.429ms on 8.2.0 now takes 9.3ms. Thanks for your help.