Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group