* Tom Lane <[EMAIL PROTECTED]> [010307 14:30] wrote: > 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. 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 - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
