On Wed, 2005-08-10 at 12:01 -0700, Shane wrote:
Hello all,
I am working with a simple table and query abut cannot seem
to get it to use the index I have created. However, if I
set enable_seqscan=false, the index is used and the query
is much faster. I have tried a vacuum analyze but to no
On Wed, 2005-08-10 at 12:01 -0700, Shane wrote:
Hello all,
I am working with a simple table and query abut cannot seem
to get it to use the index I have created. However, if I
set enable_seqscan=false, the index is used and the query
is much faster. I have tried a vacuum analyze but to no
On Wed, 2005-08-10 at 12:58 -0700, Shane wrote:
On Wed, Aug 10, 2005 at 03:31:27PM -0400, Sven Willenberger wrote:
Right off the bat (if I am interpreting the results of your explain
analyze correctly) it looks like the planner is basing its decision to
seqscan as it thinks that it needs to
Shane [EMAIL PROTECTED] writes:
I am working with a simple table and query abut cannot seem
to get it to use the index I have created.
...
explain analyze select msgid from seen where msgtime cast(now() - interval
'6 months' as timestamp(0) without time zone);
As some other people already