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