Re: Chang wal block size and database block size in Windows - Mailing list pgsql-general

From Tom Lane
Subject Re: Chang wal block size and database block size in Windows
Date
Msg-id 27333.1354164557@sss.pgh.pa.us
Whole thread Raw
In response to Chang wal block size and database block size in Windows  (classical_89 <luongnx512@gmail.com>)
List pgsql-general
classical_89 <luongnx512@gmail.com> writes:
> Hi everyone , I work with PostgreSQL on Windows XP . I want to ask you
> something .How can i change Postgres wal block size and database block size
> in Windows ?

You'd need to recompile from source, and tell the configure script
which block size you want.  (It looks like the MSVC build scripts
know how to set this, but I have no idea exactly how to set the
blocksize option with them.)

By and large, people haven't found that adjusting these values buys
a whole lot, which is why we've never bothered to make them adjustable
short of source-code changes.

            regards, tom lane


pgsql-general by date:

Previous
From: classical_89
Date:
Subject: Chang wal block size and database block size in Windows
Next
From: wd
Date:
Subject: Is there a working pgsql-fdw for PostgreSQL 9.2?