Dave, > Below I have two almost identical queries. Strangely enough the one > that uses the index is slower ???
My first guess would be that records are highly correlated by DOB and not at all by name. However, it would help if you supplied both the index definitions and what changed between the two queries to cause the index to be used. -- Josh Berkus PostgreSQL @ Sun San Francisco -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
