Postgres Pro
Downloads
Home   >   mailing lists

How to fast the REINDEX - Mailing list pgsql-performance

From raghavendra t
Subject How to fast the REINDEX
Date
Msg-id p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com
Whole thread Raw
Responses Re: How to fast the REINDEX
Re: How to fast the REINDEX
List pgsql-performance
Tree view
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
 

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Database size growing over time and leads to performance impact
Next
From: "Kevin Grittner"
Date:
Subject: Re: How to fast the REINDEX