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