Re: tweaks for write-intensive dbs ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Jonathan Vanasco <postgres(at)2xlp(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: tweaks for write-intensive dbs ?
Date: 2007-03-28 14:18:44
Message-ID: 24262.1175091524@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-28 14:43:13 Re: unexpected data beyond EOF and character encoding
Previous Message Dmitry Koterov 2007-03-28 14:05:39 How to speedup CHECKPOINTs?