Emil Briggs <emil@baymountain.com> 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