| From: | Eduardo Morras <emorrasg(at)yahoo(dot)es> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: increasing the default WAL segment size |
| Date: | 2016-08-26 08:45:06 |
| Message-ID: | 20160826104506.1e767eee4f86f6bcf26574b5@yahoo.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 24 Aug 2016 21:31:35 -0400
Robert Haas <robertmhaas(at)gmail(dot)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 <emorrasg(at)yahoo(dot)es>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dilip Kumar | 2016-08-26 09:11:24 | Re: [sqlsmith] Failed assertion in joinrels.c |
| Previous Message | Amit Langote | 2016-08-26 08:15:45 | Re: Declarative partitioning - another take |