Large block sizes support in Linux - Mailing list pgsql-hackers

From Pankaj Raghav (Samsung)
Subject Large block sizes support in Linux
Date
Msg-id hhz5ybsaxdf3vlenw4mbhzwppfwsgug5vjbyvdmtjeewnswaqw@s6ot254pmo73
Whole thread Raw
Responses Re: Large block sizes support in Linux
Re: Large block sizes support in Linux
List pgsql-hackers
Hello, 

My team and I have been working on adding Large block size(LBS)
support to XFS in Linux[1]. Once this feature lands upstream, we will be
able to create XFS with FS block size > page size of the system on Linux.
We also gave a talk about it in Linux Plumbers conference recently[2]
for more context. The initial support is only for XFS but more FSs will
follow later.

On an x86_64 system, fs block size was limited to 4k, but traditionally
Postgres uses 8k as its default internal page size. With LBS support,
fs block size can be set to 8K, thereby matching the Postgres page size.

If the file system block size == DB page size, then Postgres can have
guarantees that a single DB page will be written as a single unit during
kernel write back and not split.

My knowledge of Postgres internals is limited, so I'm wondering if there
are any optimizations or potential optimizations that Postgres could
leverage once we have LBS support on Linux?


[1] https://lore.kernel.org/linux-xfs/20240313170253.2324812-1-kernel@pankajraghav.com/
[2] https://www.youtube.com/watch?v=ar72r5Xf7x4
-- 
Pankaj Raghav



pgsql-hackers by date:

Previous
From: Isaac Morland
Date:
Subject: Re: Catalog domain not-null constraints
Next
From: Bharath Rupireddy
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation