which is more important? freq of checkpoints or the duration of them?

From: Douglas J Hunley <doug(at)hunley(dot)homeip(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: which is more important? freq of checkpoints or the duration of them?
Date: 2008-03-03 14:25:02
Message-ID: 200803030925.02931.doug@hunley.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Subject about says it all. Should I be more concerned about checkpoints
happening 'frequently' or lasting 'longer'? In other words, is it ok to
checkpoint say, every 5 minutes, if it only last a second or three or better
to have checkpoints every 10 minutes that last half a minute? Stupid examples
probably, but you get my point I hope :)
--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2008-03-03 14:32:09 Re: How to choose a disc array for Postgresql?
Previous Message Matthew 2008-03-03 12:11:55 Re: How to allocate 8 disks