On Fri, Jun 9, 2017 at 10:55 PM, Cocco Gianfranco <gianfranco.co...@eng.it> wrote: > Is there a way to fix “wal_segsize” to about 1 Gb in 9.2. version, and > “rebuild” postgreSQL server?
As long as you are able to compile your own version of Postgres and your distribution does not allow that, there is nothing preventing you to do so. > The goal is to drastically reduce the number of WALs. > Upgrading to 9.5, is the only way to fix this issue? Note that a server initialized with a segment size of X won't work with a binary compiled with a size of Y. But you can always take a logical dump of the server before the upgrade, and reload it in the version of the server with a larger segment size. The cost here is more downtime. -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance