Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group