Re: Updating a very large table

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Michael Monnerie" <michael(dot)monnerie(at)is(dot)it-management(dot)at>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Updating a very large table
Date: 2009-04-24 14:23:39
Message-ID: 49F1851B.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at> wrote:

> Question: [CLUSTER] will not rewrite the indices for that table,
> right? Then a REINDEX could be interesting too.

CLUSTER always rebuilds all indexes on the table. There's no point
doing a REINDEX afterward or dropping indexes first.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2009-04-24 14:48:51 Re: Updating a very large table
Previous Message chen shan 2009-04-24 14:04:56 How to map columns in pg_stat_activity to windows PID