Search code examples
postgresqlpostgresql-11

How to change/set the block size in Postgres? Is there any file to make the configuration?

I'm looking for the BLOCKSIZE configuration in postgres. I want to know is there a way to change/set the value?

Solution

  • For a different data block size, you would have to recompile PostgreSQL after configuring it with

    ./configure --with-blocksize=<size in kB>

    But I wouldn't recommend doing that, since I have never heard of anybody using that, and there are chances that you uncover interesting PostgreSQL bugs that way.