From: Joshua D. Drake <jd@commandprompt.com>
To: Andres Freund <andres@anarazel.de>
To: pgsql-general@postgresql.org
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
Date: Thu, 27 Apr 2017 09:31:34 -0700
Message-ID: <a842fbdf-b761-bf21-47dd-cd87d05a8d04@commandprompt.com> (raw)
In-Reply-To: <20170427155906.uudovtd62x56brmx@alap3.anarazel.de>
References: <20170425041743.ddabv2mwevcmtx5a@alap3.anarazel.de>
<20170427155906.uudovtd62x56brmx@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 04/27/2017 08:59 AM, Andres Freund wrote:
>
> Ok, based on the, few, answers I've got so far, my experience is indeed
> skewed. A number of the PG users I interacted with over the last couple
> years had WAL write ranges somewhere in the range of 500MB/s to 2.2GB/s
> (max I'veseen). At that point WAL insertion became a major bottleneck,
> even if storage was more than fast enough to keep up. To address these
> we'd need some changes, but the feedback so far suggest that it's not
> yet a widespread issue...
I would agree it isn't yet a widespread issue.
The only people that are likely going to see this are going to be on
bare metal. We should definitely plan on that issue for say 11. I do
have a question though, where you have seen this issue is it with
synchronous_commit on or off?
Thanks,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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: jd@commandprompt.com, andres@anarazel.de, pgsql-general@postgresql.org
Subject: Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
In-Reply-To: <a842fbdf-b761-bf21-47dd-cd87d05a8d04@commandprompt.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