From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de>, pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. |
Date: | 2017-04-27 16:31:34 |
Message-ID: | a842fbdf-b761-bf21-47dd-cd87d05a8d04@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-04-27 16:34:07 | Re: Questionaire: Common WAL write rates on busy servers. |
Previous Message | Andres Freund | 2017-04-27 15:59:06 | Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-04-27 16:34:07 | Re: Questionaire: Common WAL write rates on busy servers. |
Previous Message | Andres Freund | 2017-04-27 15:59:06 | Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. |