From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Gudmundsson Martin (mg) <martin.mg.gudmundsson@volvo.com>
To: Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Survey: Max TPS you've ever seen
Date: Fri, 13 Feb 2015 12:10:46 +1300
Message-ID: <54DD32F6.6010100@catalyst.net.nz> (raw)
In-Reply-To: <2E5766F28426E547AF0A2A870FAE630D32BAD8@SEGOTNC5182-N2.vcn.ds.volvo.net>
References: <CA+BNcWaAMKuXB0+rR51Ms7jMOhPtszGahWdZ7i5Eyw50c7mesQ@mail.gmail.com>
<54D9269C.9080808@archidevsys.co.nz>
<54DAA2D3.1000605@catalyst.net.nz>
<CA+BNcWax3EBmW4TMMdi3Ao4shCGvg0MUTEXyEcnCey0zitTu6Q@mail.gmail.com>
<2E5766F28426E547AF0A2A870FAE630D32BAD8@SEGOTNC5182-N2.vcn.ds.volvo.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 13/02/15 00:20, Gudmundsson Martin (mg) wrote:
> Hi all!
>
>> - checkpoint_segments 1000
>> - checkpoint_completion_target 0.9
>> - wal_buffers 256MB
>> - shared_buffers 31 gb
>> - max_connections 500
>
> I see that some of you are using wal_buffers = 256MB.
> I was under the impression that Postgres will not benefit from higher value than the segment size, i.e. 16MB. More than that will not do/help anything.
>
> What's the reasoning behind setting it to higher than 16MB? Do I have old information?
>
> Best regards, Martin
>
There was some discussion a while ago in which 32MB and 8MB both
demonstrated better performance than 16MB (probably related to the fact
the the default wal file size is 16MB). We just experimented further
with bigger values, and saw some improvement.
Cheers
Mark
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: mark.kirkwood@catalyst.net.nz, martin.mg.gudmundsson@volvo.com, luisjunior.sa@gmail.com
Subject: Re: Survey: Max TPS you've ever seen
In-Reply-To: <54DD32F6.6010100@catalyst.net.nz>
* 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