Re: Redesigning checkpoint_segments

On Fri, Jun 7, 2013 at 3:14 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
> Some findings were unsurprising, like that a direct connection
> between the servers using a cross-wired network patch cable was
> faster than plugging both machines into the same switch.  But we
> tested all of our assumptions, and re-tested the surprising ones.
> One such surprise was that the conversion ran faster, even on a
> "largish" database of around 200GB, with 3 checkpoint_segments than
> with larger settings.

!

I can't account for that finding, because my experience is that small
checkpoint_segments settings lead to *terrible* bulk restore
performance.

*scratches head*

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company