Najib Abi Fadel wrote:
Dear all,
i was reading the postgres docs concerning the
Database Physical Storage. I found that the
information present there is not enough to satisfy my
curiosity.
Are there any documentation out there that describes
in more details the Database Physical Storage of
Najib Abi Fadel wrote:
Concerning the 8KB page size, as i understood postgres
Page Size is different from the file system Block
size.
If the system block size is 4kB are there any
mechanism that guaranties that a postgres page is
stored on 2 adjacent file system blocks ?
That's the job of the
Concerning the 8KB page size, as i understood postgres
Page Size is different from the file system Block
size.
If the system block size is 4kB are there any
mechanism that guaranties that a postgres page is
stored on 2 adjacent file system blocks ?
Cause otherwise performance may suffer since
In article [EMAIL PROTECTED],
Richard Huxton [EMAIL PROTECTED] 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
%
Dear all,
i was reading the postgres docs concerning the
Database Physical Storage. I found that the
information present there is not enough to satisfy my
curiosity.
Are there any documentation out there that describes
in more details the Database Physical Storage of
potgres ?
In the Page