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

From Jim Nasby
Subject Re: [HACKERS] increasing the default WAL segment size
Date
Msg-id ed647eac-d911-c2cb-5ba0-ae3a25b90f4f@BlueTreble.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
Responses Re: [HACKERS] increasing the default WAL segment size
Re: [HACKERS] increasing the default WAL segment size
Re: [HACKERS] increasing the default WAL segment size
List pgsql-hackers
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.

I also don't see the reason for #2... or is that how initdb writes out 
the correct control file?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] Partitioned tables and relfilenode
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Restricting maximum keep segments by repslots