Re: How to fast the REINDEX

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "raghavendra t" <raagavendra(dot)rao(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to fast the REINDEX
Date: 2010-03-31 21:02:55
Message-ID: 4BB3722F02000025000302BF@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

raghavendra t <raagavendra(dot)rao(at)gmail(dot)com> wrote:

> I have a table with 40GB size, it has few indexes on it.

What does the table look like? What indexes are there?

> When i try to REINDEX on the table,

Why are you doing that?

> its take a long time.

How long?

> I tried increasing the maintenance_work_mem, but still i havnt
> find a satisfying result.

What run time are you expecting?

> Questions
> =======
> 1. What are the parameters will effect, when issuing the REINDEX
> command
> 2. Best possible way to increase the spead of the REINDEX

It's hard to answer that without more information, like PostgreSQL
version and configuration, for starters. See:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

My best guess is that you can make them instantaneous by not running
them. A good VACUUM policy should make such runs unnecessary in
most cases -- at least on recent PostgreSQL versions.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message raghavendra t 2010-03-31 21:33:48 Re: How to fast the REINDEX
Previous Message raghavendra t 2010-03-31 20:51:26 How to fast the REINDEX