May 2008
1 post
Determining Postgres Page Size
Normally 8k by default.
In 8.3.0, you can change BLCKSZ in src/include/pg_config_manual.h, and recompile from source to change it.
How can you tell what the page size of your installation is? Create a table with a single item in it. Then print the size of the table - since it fits on one page, the size is the size of the page.
[marcua@sorrel postgres]$ psql -d imdb Welcome to psql...