Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration study, step 1: bulk write performance - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Migration study, step 1: bulk write performance
Date
Msg-id 20060321212038.GD17121@surnet.cl
Whole thread Raw
In response to Re: Migration study, step 1: bulk write performance  (Ron <rjpeace@earthlink.net>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Migration study, step 1: bulk write performance
Next
From: Tom Lane
Date:
Subject: Re: Migration study, step 1: bulk write performance