Am Freitag, den 07.01.2005, 06:45 -0800 schrieb Culley Harrelson:
> Hi,
>
> I am using Postgresql 7.4. I have a table with 1.5 million rows. It
> has a primary key. VACUUM FULL ANALYZE is run every night. There are
> 2000-5000 inserts on this table every day but very few updates and
> deletes. When I select count(*) from this table it is using a
> sequence scan. Is this just life or is there some way to get this to
> do an index scan?
How do you think an index would help if you do an unconditional
count(*)?
Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
