> 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