Re: FW: Index usage

From: gnari
Subject: Re: FW: Index usage
Date: ,
Msg-id: 001101c4d200$6fbe6c40$0100000a@wp2000
(view: Whole thread, Raw)
In response to: FW: FW: Index usage  ("BBI Edwin Punzalan")
Responses: Re: FW: Index usage  ("BBI Edwin Punzalan")
List: pgsql-performance

Tree view

FW: FW: Index usage  ("BBI Edwin Punzalan", )
 Re: FW: Index usage  ("gnari", )
  Re: FW: Index usage  ("BBI Edwin Punzalan", )
   Re: FW: Index usage  ("gnari", )
    Re: FW: Index usage  ("BBI Edwin Punzalan", )
     Re: FW: Index usage  ("gnari", )
      Re: FW: Index usage  ("BBI Edwin Punzalan", )
       Re: FW: Index usage  ("Iain", )
        Re: FW: Index usage  ("BBI Edwin Punzalan", )
         Re: FW: Index usage  ("Iain", )
       Re: FW: Index usage  ("gnari", )
 Re: FW: FW: Index usage  (Richard Huxton, )
  Re: FW: FW: Index usage  ("BBI Edwin Punzalan", )
   Re: FW: FW: Index usage  (Richard Huxton, )

From: "BBI Edwin Punzalan" <>

> db=# explain analyze select date from chatlogs where date>='11/23/04' and
> date<'11/25/04';
> 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 ?

gnari






pgsql-performance by date:

From: Richard Huxton
Date:
Subject: Re: Postgres vs. MySQL
From: Christian Fowler
Date:
Subject: Re: Postgres vs. MySQL