On Wed, 24 Aug 2016 21:31:35 -0400 Robert Haas <robertmh...@gmail.com> wrote:
> Hi, > > I'd like to propose that we increase the default WAL segment size, > which is currently 16MB. It was first set to that value in commit > 47937403676d913c0e740eec6b85113865c6c8ab in October of 1999; prior to > that, it was 64MB. Between 1999 and now, there have been three > significant changes that make me think it might be time to rethink > this value: <snip> > > Thoughts? >From my ignorance, could block size affect this WAL size increase? In past (didn't tried with >9 versions) you can change disk block page size from 8KB to 16 KB or 32KB (or 4) modifing src/include/pg_config.h BLCKSZ 8192 and recompiling. (There are some mails in 1999-2002 about this topic) > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company --- --- Eduardo Morras <emorr...@yahoo.es> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
