Mark,

> That seemed to fix it. What does VACUUM ANALYZE do that VACUUM FULL does 
> not? What causes a database to need vacuuming?

See the Online Docs:
http://www.postgresql.org/docs/current/static/maintenance.html

Incidentally, just ANALYZE would probably have fixed your problem.   Please do 
suggest to the PGAdmin team that they add a FAQ item about this.


-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to