Re: [PERFORM] Optimizing >= and <= for numbers and dates

2003-10-01 Thread Dimitri Nagiev
-- Index Scan using mytable_query on mytable (cost=0.00..148.56 rows=43 width=562) (actual time=41.22..41.27 rows=4 loops=1) Index Cond: (mydate = '2003-09-01'::date) Total runtime: 41.34 msec (3 rows) > On Wed, 2003-10-01 at 13:30, Dimitri Nagiev wrote:

[PERFORM] Optimizing >= and <= for numbers and dates

2003-10-01 Thread Dimitri Nagiev
Hi all, I haven't found any official documentation about the postgres sql optimizer on the web, so please forgive me if there is such a document and point me to the right direction. I've got the following problem: I cannot make the postgres SQL Optimizer use an index on a date field to filter out