John Lister <john.lis...@kickstone.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to