Re: Postgresql Page Layout details - Mailing list pgsql-general

From ptjm@news-reader-radius.uniserve.com (Patrick TJ McPhee)
Subject Re: Postgresql Page Layout details
Date
Msg-id 13t1jvo6hi69f15@corp.supernews.com
Whole thread Raw
In response to Postgresql Page Layout details  (Najib Abi Fadel <nabifadel@yahoo.com>)
List pgsql-general
In article <47CFAD1F.7080801@archonet.com>,
Richard Huxton <dev@archonet.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@interlog.com

pgsql-general by date:

Previous
From: newbiegalore
Date:
Subject: Re: staring pgsql on fedora 8
Next
From: Tom Lane
Date:
Subject: Re: staring pgsql on fedora 8