Re: index does not improve performance

> BTW, have you VACUUM ANALYZE'd this table? What version of Pg are you

On your advice I did VACUUM ANALYZE, and it did help! From 5.5 seconds
I'm down to 3.4 seconds.

I'm using PostgreSQL 7.1.3, RPM binary.


> running? The output for 'explain' for these queries (with and without
> index) would be helpful.

With index:
Aggregate  (cost=11292.20..11292.20 rows=1 width=0)
  ->  Seq Scan on log  (cost=0.00..10679.25 rows=245182 width=0)

Without index:
Aggregate  (cost=11292.20..11292.20 rows=1 width=0)
  ->  Seq Scan on log  (cost=0.00..10679.25 rows=245182 width=0)


--
Milos Prudek