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?
In response to
pgsql-general by date
|Next:||From: Denis Gasparin||Date: 2007-03-28 08:30:00|
|Subject: Prepared queries vs Non-prepared|
|Previous:||From: Jonathan Vanasco||Date: 2007-03-28 07:10:08|
|Subject: tweaks for write-intensive dbs ?|