Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to minimize the impact of checkpoints (resend) - Mailing list pgsql-general

From Doug McNaught
Subject Re: Trying to minimize the impact of checkpoints (resend)
Date
Msg-id 87pt85zwe7.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Trying to minimize the impact of checkpoints (resend)  (jao@geophile.com)
List pgsql-general
Tree view 
jao@geophile.com writes:

> Does anyone have any experience in modifying the priority of the
> checkpoint process itself, (re-nicing it)?

Unfortunately for you, re-nicing doesn't generally affect a processes
I/O rate--it's meant for CPU-bound processes.

It might be possible to add code to "throttle" the checkpoint process
(similar to what was done for VACUUM) but I don't know for sure...

-Doug

pgsql-general by date:

Previous
From: jao@geophile.com
Date:
Subject: Trying to minimize the impact of checkpoints (resend)
Next
From: Tom Lane
Date:
Subject: Re: Trying to minimize the impact of checkpoints (resend)