On 6-Mar-08, at 12:26 PM, Josh Berkus wrote:
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.
The two queries were run 2 seconds apart, there were no changes
between. I'll get the index definitions.
Dave
--
Josh Berkus
PostgreSQL @ Sun
San Francisco
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
