> Thank you for your help. > > I am already running the vacuumdb full.............after it finishes (I guess > it will take a > while to finish...) how should I execute this REINDEX ? Is there a single > command to reindex the > entire database?
Here is a link that describes its use: http://www.postgresql.org/docs/8.2/interactive/app-reindexdb.html Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend