On Fri, Jun 9, 2017 at 10:55 PM, Cocco Gianfranco <Gianfranco.Cocco@xxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
