Re: Why does it not use the index?

Well duh. Crap. I remember that NOW that I've read everyones comments (thanks by the way!). I do remember reading that,
andhave placed the 'vacumedb -z' command in crontabs on databases in the past. Just forgot all about that - I guess it
isbecause most of the databases I've set up on postgresql get to the point where they just simply run, and run, and
run,and run. A nice thing about postgresql - wrap it in some automated maintenance and it becomes so stable it is
nearlyforgotten about! Vacuum analyze is one of those items where if you don't use it (manually) often, you lose it
(andforget the reason why to use it). 

Thanks again!

--
-----------------------------------------------------------------------------
PG..                                                 philip@tildesoftware.com
Law of probable dispersal: Whatever it is that hits the fan will not be
evenly distributed.