Re: Why the difference in plans ? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Why the difference in plans ?
Date
Msg-id 200803060926.38708.josh@agliodbs.com
Whole thread Raw
In response to Why the difference in plans ?  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Why the difference in plans ?
Re: Why the difference in plans ?
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance of aggregates over set-returning functions
Next
From: Tom Lane
Date:
Subject: Re: count * performance issue