Postgres Pro
Downloads
Home   >   mailing lists

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

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

> but the updating of the records as having been audited ( a bool flag )
> takes 5-10 minutes per set.

What's the limiting factor? Disk? CPU?

Any chance of seeing the queries that are causing the problem?
How many rows do they affect?
Do you have lots of indexes or foreign-key constraints that might be
taking up time to update/check?
Do your logs show messages about checkpointing happening too often?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Jonathan Vanasco
Date:
Subject: tweaks for write-intensive dbs ?
Next
From: Denis Gasparin
Date:
Subject: Prepared queries vs Non-prepared