Re: Bumping block size to 16K on FreeBSD... - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Bumping block size to 16K on FreeBSD...
Date
Msg-id 3F4F02DD.50905@paradise.net.nz
Whole thread Raw
In response to Re: Bumping block size to 16K on FreeBSD...  (Curt Sampson <cjs@cynic.net>)
List pgsql-hackers
I am not 100% sure that 16K blocksize is the best size, for instance :

Using FreebSD 5.1 - I got the best read and write performance using a 
blocksize of 32K with 4K fragments - [ reading and writing 8K blocks, 
ufs1 and ufs2 fs ].

I dont have the results in front of me, but I think I tried fs 
blocksizes from 4K upwards....

I am also not convinced that using 16K in Pg will be better than 8K (you 
would expect sequential performance to improve, but maybe at the expense 
of random ....)

regards

Mark



pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Nasty problem in hash indexes
Next
From: Hannu Krosing
Date:
Subject: Re: ALTER TABLE