Re: increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: increasing the default WAL segment size
Дата
Msg-id 20160825195110.GA27671@momjian.us
обсуждение исходный текст
Ответ на Re: increasing the default WAL segment size  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Aug 25, 2016 at 04:21:33PM +0100, Simon Riggs wrote:
> If we do have the pain of change, should we also consider making WAL
> files variable length? What do we gain by having the files all the
> same size? ISTM better to have WAL files that vary in length up to 1GB
> in size.
> 
> (This is all about XLOG_SEG_SIZE; I presume XLOG_BLCKSZ can stay as it
> is, right?)

I think having WAL use variable length files would add complexity for
recycling WAL files.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: UPSERT strange behavior
Следующее
От: Robert Haas
Дата:
Сообщение: Re: increasing the default WAL segment size