Re: Lowering the default wal_blocksize to 4K - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Lowering the default wal_blocksize to 4K
Date
Msg-id 240625.1696907790@sss.pgh.pa.us
Whole thread Raw
In response to Lowering the default wal_blocksize to 4K  (Andres Freund <andres@anarazel.de>)
Responses Re: Lowering the default wal_blocksize to 4K
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> There's an alternative approach we could take, which is to write in 4KB
> increments, while keeping 8KB pages. With the current format that's not
> obviously a bad idea. But given there aren't really advantages in 8KB WAL
> pages, it seems we should just go for 4KB?

Seems like that's doubling the overhead of WAL page headers.  Do we need
to try to skinny those down?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag
Next
From: Peter Smith
Date:
Subject: Re: PGDOCS - add more links in the pub/sub reference pages