Re: unbalanced indexes -> fixed via dump/restore?

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [010307 14:30] wrote:
> will trillich <will(at)serensoft(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]