Re: Postgresql Page Layout details

In article <47CFAD1F(dot)7080801(at)archonet(dot)com>,
Richard Huxton <dev(at)archonet(dot)com> wrote:

% Some people used to suggest that a larger blocksize helped with specific
% disk systems & disk block sizes. This means changing the setting in one
% of the header files and recompiling. It also means your database files
% aren't compatible with a normally-compiled version of PostgreSQL. I've
% not seen anyone mention it recently, so maybe it's just not worth the
% trouble any more.

I suspect there's just not much to say about it. It makes good
sense to match the database block size to the filesystem block size,
particularly if the filesystem blocks are larger than 8k. It's
not exactly a lot of trouble to set it up, assuming you compile the
database yourself anyway, and it allows the database to do a better
job of I/O management.

--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com