Re: Block / Page Size Optimization

2019-04-17 Thread Bruce Momjian
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 inc

Re: Block / Page Size Optimization

2019-04-15 Thread Tomas Vondra
On Mon, Apr 08, 2019 at 11:09:07AM -0400, Gunther wrote: Hi all, I am sure this should be a FAQ, but I can't see a definitive answer, only chatter on various lists and forums. Default page size of PostgreSQL is 8192 bytes. Default IO block size in Linux is 4096 bytes. I can set an XFS file sy

Re: Block / Page Size Optimization

2019-04-08 Thread Andres Freund
Hi, On 2019-04-08 11:09:07 -0400, Gunther wrote: > I can set an XFS file system with 8192 bytes block size, but then it does > not mount on Linux, because the VM page size is the limit, 4096 again. > > There seems to be no way to change that in (most, common) Linux variants. In > FreeBSD there ap

Block / Page Size Optimization

2019-04-08 Thread Gunther
Hi all, I am sure this should be a FAQ, but I can't see a definitive answer, only chatter on various lists and forums. Default page size of PostgreSQL is 8192 bytes. Default IO block size in Linux is 4096 bytes. I can set an XFS file system with 8192 bytes block size, but then it does not mou