* Tom Lane <tgl@sss.pgh.pa.us> [010307 14:30] wrote:
> will trillich <will@serensoft.com> writes:
> > A)
> > pg_dump -c mydb > db.out.sql
> > and then
> > psql mydb < db.out.sql
> > periodically?
>
> > or is it better to
>
> > B) merely 'reindex' on occasion?
>
> Plain old DROP INDEX / CREATE INDEX is probably the best-trodden path.
> Your (A) seems like vastly more work than is needed. (B) might be
> marginally easier than DROP/CREATE, but I'm not sure how much I trust
> REINDEX; it's not been around all that long.
Is there a way to do this atomically, meaning so that no one can
get at the table after dropping, but before recreating the index?
lock the table during?
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
