Page 1 of 1

how to change block size of postgresql

PostPosted: Fri May 15, 2009 3:56 pm
by 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.

Re: how to change block size of postgresql

PostPosted: Fri May 15, 2009 4:06 pm
by 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.

Re: how to change block size of postgresql

PostPosted: Fri May 15, 2009 6:21 pm
by 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.

Re: how to change block size of postgresql

PostPosted: Sat May 16, 2009 9:35 am
by kraada
This post does mention a way to do it for PostgreSQL 8.3 -- you still do need to recompile though.

highfalutin