Re: increasing the default WAL segment size

On Wed, 24 Aug 2016 21:31:35 -0400
Robert Haas <robertmhaas@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.hBLCKSZ 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 <emorrasg@yahoo.es>