how to change block size of postgresql

[zedjr]

Where exactly do i change the postgresql block size. I cant find it in postgres.conf file. it currently uses 8kb am told and want to change it to 16kb.

[kraada]

I believe the only way to change that value is to compile PostgreSQL from source with the --with-blocksize option set. I don't see that option for PostgreSQL 8.3, so you may need to use the new PostgreSQL 8.4 beta (preliminary tests indicate that PostgreSQL 8.4 will work fine with PT3). See this page for more on the installation from source procedure on PostgreSQL 8.4beta.

[zedjr]

Can u ask dave as he might know. I have seen posts at other sites about setting block size in 8.3 and 8.2.

[kraada]

This post does mention a way to do it for PostgreSQL 8.3 -- you still do need to recompile though.