Re: Migration study, step 1: bulk write performance

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: Mikael Carneholm <Mikael(dot)Carneholm(at)WirelessCar(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Migration study, step 1: bulk write performance
Date: 2006-03-21 21:20:38
Message-ID: 20060321212038.GD17121@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ron wrote:

> IIRC, Josh Berkus did some benches that suggests in pg 8.x a value of
> 64 - 256 is best for checkpoint_segments as long as you have the RAM
> available.

I think you are confusing checkpoint_segments with wal_buffers.
checkpoint_segments certainly has little to do with available RAM!

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-03-21 21:56:25 Re: Migration study, step 1: bulk write performance
Previous Message Scott Marlowe 2006-03-21 21:19:22 Re: Migration study, step 1: bulk write performance