How to fast the REINDEX

From: raghavendra t <raagavendra(dot)rao(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to fast the REINDEX
Date: 2010-03-31 20:51:26
Message-ID: p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-03-31 21:02:55 Re: How to fast the REINDEX
Previous Message Alvaro Herrera 2010-03-31 20:47:57 Re: Database size growing over time and leads to performance impact