Re: [GENERAL] Postgresql Page Layout details

2008-03-06 Thread Richard Huxton
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

Re: [GENERAL] Postgresql Page Layout details

2008-03-06 Thread Richard Huxton
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

Re: [GENERAL] Postgresql Page Layout details

2008-03-06 Thread Najib Abi Fadel
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

Re: [GENERAL] Postgresql Page Layout details

2008-03-06 Thread Patrick TJ McPhee
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 %

[GENERAL] Postgresql Page Layout details

2008-03-05 Thread Najib Abi Fadel
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