I'm having another problem with a query that takes to long, because
the appropriate index is not used.
I found some solutions to this problem, but I think Postgres should do
an index scan in all cases.
To show the problem I've attached a small script with a testcase.
Thanks in advance
Description: text/plain (1.3 KB)
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2005-05-30 16:19:40|
|Subject: Re: Postgresql and xeon.|
|Previous:||From: Michael Fuhr||Date: 2005-05-30 13:54:29|
|Subject: Re: timestamp indexing|