Postgres Pro
Downloads
Home   >   mailing lists

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

From Kuntal Ghosh
Subject Re: [HACKERS] increasing the default WAL segment size
Date
Msg-id CAGz5QCLE5vs8pk-DhNno_bgYQ9Jn8AQHjNiT33x9m8k3XsRXDA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view 
On Tue, Feb 28, 2017 at 9:45 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> On 2/24/17 6:30 AM, Kuntal Ghosh wrote:
>>
>> * You're considering any WAL file with a power of 2 as valid. Suppose,
>> the correct WAL seg size is 64mb. For some reason, the server
>> generated a 16mb invalid WAL file(maybe it crashed while creating the
>> WAL file). Your code seems to treat this as a valid file which I think
>> is incorrect. Do you agree with that?
>
>
> Detecting correct WAL size based on the size of a random WAL file seems like
> a really bad idea to me.
+1



-- 
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Restricting maximum keep segments by repslots
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables