Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating a very large table - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Updating a very large table
Date
Msg-id 49F1851B.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Updating a very large table  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
Tree view 
Michael Monnerie <michael.monnerie@is.it-management.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

pgsql-admin by date:

Previous
From: chen shan
Date:
Subject: How to map columns in pg_stat_activity to windows PID
Next
From: Michael Monnerie
Date:
Subject: Re: Updating a very large table