On Wed, Mar 31, 2010 at 5:33 PM, raghavendra t <raagavendra.rao@xxxxxxxxx> wrote: > >>>Why are you doing that? > Our table face lot of updates and deletes in a day, so we prefer reindex to > update the indexes as well overcome with a corrupted index. > do you have a corrupted index? if not, there is nothing to do... REINDEX is not a mantenance task on postgres -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance