From: "BBI Edwin Punzalan" <edwin(at)bluebamboo(dot)ph>
> db=# explain analyze select date from chatlogs where date>='11/23/04' and
> NOTICE: QUERY PLAN:
> Seq Scan on chatlogs (cost=0.00..24763.19 rows=9200 width=4) (actual
> time=0.45..4268.00 rows=23787 loops=1)
> Total runtime: 4282.81 msec
> How come a query on the current date filter uses an index and the others
> does not? This makes indexing to speed up queries quite difficult.
have you ANALYZED the table lately ?
what version postgres are you using ?
In response to
pgsql-performance by date
|Next:||From: songtebo||Date: 2004-11-24 09:36:56|
|Previous:||From: Greg Stark||Date: 2004-11-24 08:14:17|
|Subject: Re: Data type to use for primary key|