On Wed, 19 May 2010, David Jarvis wrote:
> extract( YEAR FROM m.taken ) BETWEEN 1900 AND 2009 AND
That portion of the WHERE clause cannot use an index on m.taken. Postgres
does not look inside functions (like extract) to see if something
indexable is present. To get an index to work, you could create an index
on (extract(YEAR FROM m.taken)).
Here we go - the Fairy Godmother redundancy proof.
-- Computer Science Lecturer
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2010-05-20 13:56:50|
|Subject: Re: Optimize date query for large child tables: GiST or GIN? |
|Previous:||From: Thom Brown||Date: 2010-05-20 08:33:15|
|Subject: Re: Optimize date query for large child tables: GiST or GIN?|