Postgres Pro
Downloads
Home   >   mailing lists

Re: Random Page Cost and Planner - Mailing list pgsql-performance

From David Jarvis
Subject Re: Random Page Cost and Planner
Date
Msg-id AANLkTil7Hq5RIqAHVwXbpKkfdtZSKg_UsQeNgJuTGMdI@mail.gmail.com
Whole thread Raw
In response to Random Page Cost and Planner  (David Jarvis <thangalin@gmail.com>)
List pgsql-performance
Tree view
Hi,

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.

Dave

pgsql-performance by date:

Previous
From: Łukasz Dejneka
Date:
Subject: Re: Certain query eating up all free memory (out of memory error)
Next
From: Joachim Worringen
Date:
Subject: performance of temporary vs. regular tables