From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Questionaire: Common WAL write rates on busy servers. |
Date: | 2017-04-27 17:29:48 |
Message-ID: | 80f280c1-910f-7eae-33a2-fd0cfc9ee8c9@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On 04/27/2017 09:34 AM, Andres Freund wrote:
> On 2017-04-27 09:31:34 -0700, Joshua D. Drake wrote:
>> On 04/27/2017 08:59 AM, Andres Freund wrote:
>>
>> I would agree it isn't yet a widespread issue.
>
> I'm not yet sure about that actually. I suspect a large percentage of
> people with such workloads aren't lingering lots on the lists.
That would probably be true. I was thinking of it more as the "most new
users are in the cloud" and the "cloud" is going to be rare that a cloud
user is going to be able to hit that level of writes. (at least not
without spending LOTS of money)
>
>
>> 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.
>
> "plan on that issue" - heh. We're talking about major engineering
> projects here ;)
Sorry, wasn't trying to make light of the effort. :D
>
>
>> I do have a question though, where you have seen this issue is it with
>> synchronous_commit on or off?
>
> Both. Whether that matters or not really depends on the workload. If you
> have bulk writes, it doesn't really matter much.
Sure, o.k.
Thanks,
Andres
>
> - Andres
>
--
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 | Jacob Scott | 2017-04-27 17:33:17 | Generalized pg_stat_statements? |
Previous Message | Andres Freund | 2017-04-27 16:34:07 | Re: Questionaire: Common WAL write rates on busy servers. |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-04-27 17:35:40 | Re: Questionaire: Common WAL write rates on busy servers. |
Previous Message | Andres Freund | 2017-04-27 16:34:07 | Re: Questionaire: Common WAL write rates on busy servers. |