> You can prevent postgres from using the index on node by changing the reference in the WHERE clause to an expression, like so:
> SELECT * FROM public.stat WHERE node||'' = '1010101010' AND
> ("date" <= '2008-06-30'::date AND "date" >= '2008-01-01'::date);
> Perhaps this will lead the optimizer to choose the index on date. However, I have noticed reluctance in the postgres optimizer to use multi-column indexes, presumably because the increased size of the indexed values lowers expectations for performance of the index.
I think you are right about the multi-column usage.
When I use node||'' instead of node, it will do a seq scan.
In response to
pgsql-general by date
|Next:||From: Craig Ringer||Date: 2008-07-29 07:11:56|
|Subject: Re: How to give input a file for a stored procedure|
|Previous:||From: Klint Gore||Date: 2008-07-29 05:17:40|
|Subject: Re: why can't I load pgxml.sql|