I changed the date comparison to be based on year alone:
extract(YEAR FROM sc.taken_start) >= 1900 AND
extract(YEAR FROM sc.taken_end) <= 2009 AND
The indexes are now always used; if someone wants to explain why using the
numbers works (a constant) but using a date (another constant?) does not
work, I'd really appreciate it.
Thanks again, everybody, for your time and help.
In response to
pgsql-performance by date
|Next:||From: Joachim Worringen||Date: 2010-05-25 07:59:56|
|Subject: performance of temporary vs. regular tables|
|Previous:||From: Łukasz Dejneka||Date: 2010-05-25 06:37:11|
|Subject: Re: Certain query eating up all free memory (out of memory error)|