Re: One large v. many small - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: One large v. many small
Date
Msg-id 200302021016.h12AG0e19235@candle.pha.pa.us
Whole thread Raw
In response to Re: One large v. many small  (Curt Sampson <cjs@cynic.net>)
List pgsql-performance
Curt Sampson wrote:
> So the tradeoff there is really, can you afford the time for the CLUSTER?
> (In a system where you have a lot of maintenance time, probably. Though if
> it's a huge table, this might need an entire weekend. In a system that needs
> to be up 24/7, probably not, unless you have lots of spare I/O capacity.)
> Just out of curiousity, how does CLUSTER deal with updates to the table while
> the CLUSTER command is running?

CLUSTER locks the table, so no updates can happen during a cluster.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Curt Sampson
Date:
Subject: Re: One large v. many small
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres 7.3.1 poor insert/update/search performance