Chang wal block size and database block size in Windows
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 ?.I had tried search in postgresql.conf but seem these params not
list in this file , i think it would be place at somewhere
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Chang-wal-block-size-and-database-block-size-in-Windows-tp5734027.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general