reindex should be faster, since you're not dumping/reloading the table contents on top of rebuilding the index, you're just rebuilding the index.
Robert Treat emdeon Practice Services Alachua, Florida On Wed, 2005-10-12 at 13:32, Steve Poe wrote: > > Would it not be faster to do a dump/reload of the table than reindex or > is it about the same? > > 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 -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster