Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Greg Smith <greg(at)2ndQuadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Daniel Farina <daniel(at)heroku(dot)com>, "Harold A(dot) Giménez" <harold(dot)gimenez(at)gmail(dot)com>
Subject: Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Date: 2012-07-18 04:20:39
Message-ID: 50063997.9030509@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On 07/18/2012 12:00 PM, Greg Smith wrote:

> The second justification for the split was that it seems easier to get
> a low power result from, which I believe was the angle Peter Geoghegan
> was working when this popped up originally. The checkpointer has to
> run sometimes, but only at a 50% duty cycle as it's tuned out of the
> box. It seems nice to be able to approach that in a way that's power
> efficient without coupling it to whatever heartbeat the BGW is running
> at. I could even see people changing the frequencies for each
> independently depending on expected system load. Tune for lower power
> when you don't expect many users, that sort of thing.
>
Yeah - I'm already seeing benefits from that on my laptop, with much
less need to stop Pg when I'm not using it.

--
Craig Ringer

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-07-18 04:31:53 Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Previous Message Bruce Momjian 2012-07-18 04:18:30 Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2012-07-18 04:57:53 Re: Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous Message Greg Smith 2012-07-18 04:00:08 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)