| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Eduardo Morras <emorrasg(at)yahoo(dot)es> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: increasing the default WAL segment size |
| Date: | 2016-08-28 14:08:34 |
| Message-ID: | CA+Tgmobn8A2xo_-jRK_zpqdU-+5tXN+j+pkbJ-TAe9ih=271CA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Aug 26, 2016 at 4:45 AM, Eduardo Morras <emorrasg(at)yahoo(dot)es> wrote:
> 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)
Yeah, I think that's still supposed to work although I don't know
whether anyone has tried it lately. It is a separate topic from this
issue, though.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-08-28 14:41:59 | Re: Bogus sizing parameters in some AllocSetContextCreate calls |
| Previous Message | Robert Haas | 2016-08-28 14:07:47 | Re: increasing the default WAL segment size |