From: mark <dvlhntr@gmail.com>
To: 'Benjamin Krajmalnik' <kraj@servoyant.com>
To: 'Greg Smith' <greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware recommendations
Date: Mon, 13 Dec 2010 20:29:16 -0700
Message-ID: <00b701cb9b3f$17c8ed80$475ac880$@com> (raw)
In-Reply-To: <F4E6A2751A2823418A21D4A160B689887B0AE5@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B689887B0A4C@fletch.stackdump.local>
<F4E6A2751A2823418A21D4A160B689887B0A4D@fletch.stackdump.local>
<4D0341D4.9000207@2ndquadrant.com>
<F4E6A2751A2823418A21D4A160B689887B0AE5@fletch.stackdump.local>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
> Sent: Monday, December 13, 2010 1:45 PM
> To: Greg Smith
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Hardware recommendations
>
>
>
> > -----Original Message-----
> > From: Greg Smith [mailto:greg@2ndquadrant.com]
> > Sent: Saturday, December 11, 2010 2:18 AM
> > To: Benjamin Krajmalnik
> > Cc: pgsql-performance@postgresql.org
> > Subject: Re: [PERFORM] Hardware recommendations
> >
> > Have you increased checkpoint parameters like checkpoint_segments?
> You
> > need to avoid having checkpoints too often if you're going to try and
> > use 4GB of memory for shared_buffers.
> >
>
> Yes, I have it configured at 1024 checkpoint_segments, 5min timeout,0.9
> compiostat -x 5letion_target
I would consider bumping that checkpoint timeout duration to a bit longer
and see if that helps any if you are still looking for knobs to fiddle with.
YMMV.
-Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dvlhntr@gmail.com, kraj@servoyant.com, greg@2ndquadrant.com
Subject: Re: Hardware recommendations
In-Reply-To: <00b701cb9b3f$17c8ed80$475ac880$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox