Postgres Pro
Downloads
Home   >   mailing lists

Re: tweaks for write-intensive dbs ? - Mailing list pgsql-general

From Tom Lane
Subject Re: tweaks for write-intensive dbs ?
Date
Msg-id 24262.1175091524@sss.pgh.pa.us
Whole thread Raw
In response to Re: tweaks for write-intensive dbs ?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Richard Huxton <dev@archonet.com> writes:
> Jonathan Vanasco wrote:
>> can anyone offer some suggestions on tweaking a system for
>> write-intensive operations?

> What's the limiting factor? Disk? CPU?

If it's I/O bound, you probably need to increase checkpoint_segments.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephen Harris
Date:
Subject: Slow sequential scans on one DB but not another; fragmentation?
Next
From: Tom Lane
Date:
Subject: Re: unexpected data beyond EOF and character encoding