will trillich <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
