Would it not be faster to do a dump/reload of the table than reindex or is it about the same?
Advertising
Steve Poe On Wed, 2005-10-12 at 13:21 -0400, Tom Lane wrote: > Emil Briggs <[EMAIL PROTECTED]> writes: > >> Not yet, the db is in production use and I have to plan for a down-time > >> for that... or is it not impacting the activity on the table ? > > > It will cause some performance hit while you are doing it. > > It'll also lock out writes on the table until the index is rebuilt, > so he does need to schedule downtime. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
