Yes, the database is being vacuum-ed and analyzed on a daily basis. Our version is 7.2.1
-----Original Message----- From: gnari [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 4:35 PM To: BBI Edwin Punzalan; [EMAIL PROTECTED] Subject: Re: [PERFORM] FW: Index usage From: "BBI Edwin Punzalan" <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
