How to fast the REINDEX

[raghavendra t <raagavendra.rao@xxxxxxxxx>]

Hi All,

 

I have a table with 40GB size, it has few indexes on it. When i try to REINDEX on the table, its take a long time. I tried increasing the maintenance_work_mem, but still i havnt find a satisfying result.

 

Questions

=======

1. What are the parameters will effect, when issuing the REINDEX command

2. Best possible way to increase the spead of the REINDEX

 

Thanks in Advance

 

Regards

Raghavendra