> Have you run analyze on the table?
> How selective is the condition node = '1010101010' and the date range. In
> particular, do you have an idea what percentange of the table fits into
> that date range?
There are around 1000 nodes and there is data for two years, so it must
be around 1/4000 of all rows
> What about the "type" column? You have it in the index, but not in your
> query. Have you tried adding type to the query? Will that make it more
Why haven't I tried that ... That did the trick, thanks!
In response to
pgsql-general by date
|Next:||From: Asko Oja||Date: 2008-07-29 08:35:09|
|Subject: Re: Clone a database to other machine|
|Previous:||From: Poul Møller Hansen||Date: 2008-07-29 07:25:10|
|Subject: Re: Date index not used when selecting a date range|