Re: Block / Page Size Optimization - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Block / Page Size Optimization
Date
Msg-id 20190417201459.kmddlcnevt2mp4cv@momjian.us
Whole thread Raw
In response to Re: Block / Page Size Optimization  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-performance
On Mon, Apr 15, 2019 at 06:19:06PM +0200, Tomas Vondra wrote:
> On Mon, Apr 08, 2019 at 11:09:07AM -0400, Gunther wrote:
> > What really is the theoretical issue with the file system block size?
> > Where does -- in theory -- the benefit come from of using an XFS block
> > size of 8 kB, or even increasing the PostgreSQL page size to 16 kB and
> > then the XFS block size also to 16 kB? I remember having seen standard
> > UFS block sizes of 16 kB. But then why is Linux so tough on refusing to
> > mount an 8 kB XFS because it's VM page size is only 4 kB?
> > 
> > Doesn't this all have one straight explanation?
> > 
> 
> Not really. AFAICS the limitation is due to a mix of reasons, and is
> mostly a trade-off between code complexity and potential benefits. It's
> probably simpler to manage filesystems with pages smaller than a memory
> page, and removing the limitation did not seem very useful compared to
> the added complexity. But it's probably a question for kernel hackers.

My guess is that having the file system block size be the same as the
virtual memory page size allows flipping pages from kernel to userspace
memory much simpler.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Pg10 : Client Configuration for Parallelism ?
Next
From: Stephan Schmidt
Date:
Subject: Best Filesystem for PostgreSQL