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.
regards, tom lane