Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se> writes:
> I sent this to general earlier but I was redirected to performance.
Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out before.
See for instance this thread:
which show three different ways of getting the planner to do something
sane with an index range bound like "now() - interval".
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Chris Browne||Date: 2004-10-13 15:52:28|
|Subject: Opteron vs RHAT|
|Previous:||From: ken||Date: 2004-10-13 14:37:43|
|Subject: Re: query problem|
pgsql-general by date
|Next:||From: Robert Treat||Date: 2004-10-13 15:11:29|
|Subject: Re: [GENERAL] Reusable pl/pgsql samples ?|
|Previous:||From: Jason Tesser||Date: 2004-10-13 15:00:04|
|Subject: converting database to unicode|