John Lister <john.lister@xxxxxxxxxxxxx> writes: > Although saying that.. > reindex now works, but doing a vacuum verbose complains that the index > is out of step with the table and i should reindex.. > would i be better shutting the db down, restarting in standalone mode > (and also using the -P option) before reindexing? Yeah, if you have reason not to trust the system indexes then -P is a good idea until they are fixed. Standalone mode per se isn't that important --- you could do this from a regular session with -P specified via PGOPTIONS. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
