classical_89 <luongnx512@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general