Re: increasing the default WAL segment size - Mailing list pgsql-hackers

From Robert Haas
Subject Re: increasing the default WAL segment size
Date
Msg-id CA+Tgmoa_eqdyEyJyzpbhz05S0+QAG2kYMC8tCwVL7GYYw0AgcQ@mail.gmail.com
Whole thread Raw
In response to Re: increasing the default WAL segment size  (Stephen Frost <sfrost@snowman.net>)
Responses Re: increasing the default WAL segment size  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Thu, Aug 25, 2016 at 10:34 AM, Stephen Frost <sfrost@snowman.net> wrote:
>> My point wasn't really that archive_command should actually be simple.
>> My point was that if it's being run multiple times per second, there
>> are additional challenges that wouldn't arise if it were being run
>> only every 5-10 seconds.
>
> My point was that the concerns about TCP/ssh startup costs, which was
> part of your point #1 in your initial justification for the change,
> have been addressed through tooling.

It's good to know that some tool sets have addressed that, but I'm
pretty certain that not every tool set has done so, probably not even
all of the ones in common use.  Anyway, I think the requirements we
impose on archive_command today are just crazy.  All other things
being equal, changes that make it easier to write a decent one are
IMHO going in the right direction.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: increasing the default WAL segment size
Next
From: Robert Haas
Date:
Subject: Re: increasing the default WAL segment size