Re: Why does a simple query not use an obvious index?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Guy Thornley <guy(at)esphion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why does a simple query not use an obvious index?
Date: 2004-08-30 15:41:05
Message-ID: 87k6vgiqge.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Guy Thornley <guy(at)esphion(dot)com> writes:

> "stats__ends_at" btree (stats__ends_at("at", resolution, "values"))

Postgres 7.4 doesn't have any stats on functional indexes. So it's back to
just guessing at the selectivity of this. 8.0 does gather stats for functional
indexes so it should be better off.

--
greg

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2004-08-30 16:02:28 Re: Why does a simple query not use an obvious index?
Previous Message Tom Lane 2004-08-30 15:41:02 Re: Why does a simple query not use an obvious index?