Re: Why the difference in plans ?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>
Subject: Re: Why the difference in plans ?
Date: 2008-03-06 17:26:38
Message-ID: 200803060926.38708.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-03-06 17:29:22 Re: count * performance issue
Previous Message Bruce Momjian 2008-03-06 17:23:21 Re: Performance of aggregates over set-returning functions