pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Grittner <kgrittn@ymail.com>
To: Johnny Tan <johnnydtan@gmail.com>
Cc: ac@hsk.hk <ac@hsk.hk>
Cc: Josh Krupka <jkrupka@gmail.com>
Cc: Alex Kahn <alex@paperlesspost.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: postgresql.conf recommendations
Date: Wed, 6 Feb 2013 13:12:50 -0800 (PST)
Message-ID: <1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CABMVzL0j=quCGWEdHO922kOjzmbqA7CntwMtE6abT=cx+sZaxQ@mail.gmail.com>
References: <CABMVzL2y8mRM5C9xxejAyDqe0i1S78RAE3cEATGYNf5Ktz_Zdg@mail.gmail.com>
	<CAB6McgXMFS2XD_inm5LMSmZpYMoXm8mzF6t3JXVyJAqi_-98OA@mail.gmail.com>
	<CABMVzL3mmx8KOBCrVQzff3FciXg_DJGULd4f3an4a417FUb1XQ@mail.gmail.com>
	<CAB6McgUt0tBgZCYjRKgpPt41XPYLXwA8tcXDTp_vLTvwA1m30w@mail.gmail.com>
	<13A05E96-01A0-4B0A-8EA3-2A3B7FDF6838@hsk.hk>
	<1360154987.89420.YahooMailNeo@web162901.mail.bf1.yahoo.com>
	<CABMVzL0j=quCGWEdHO922kOjzmbqA7CntwMtE6abT=cx+sZaxQ@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Johnny Tan <johnnydtan@gmail.com> wrote:

> Wouldn't this be controlled by our checkpoint settings, though? 

Spread checkpoints made the issue less severe, but on servers with
a lot of RAM I've had to make the above changes (or even go lower
with shared_buffers) to prevent a burst of writes from overwhelming
the RAID controllers battery-backed cache.  There may be other
things which could cause these symptoms, so I'm not certain that
this will help; but I have seen this as the cause and seen the
suggested changes help.

-Kevin


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (32+ messages)  latest in thread

Message-ID: <1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com>
Permalink:  ../1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com/
Also on:    postgresql.org/message-id/1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com

 · 

reply
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: kgrittn@ymail.com, johnnydtan@gmail.com, ac@hsk.hk, jkrupka@gmail.com, alex@paperlesspost.com
  Subject: Re: postgresql.conf recommendations
  In-Reply-To: <1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.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