Re: How do you change the size of the WAL files?

Поиск
Список
Период
Сортировка
От Ron Somaraju
Тема Re: How do you change the size of the WAL files?
Дата
Msg-id 2389867A-56EF-42B4-BE2F-3D7078EEE33F@masergy.com
обсуждение исходный текст
Ответ на Re: How do you change the size of the WAL files?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How do you change the size of the WAL files?  (John R Pierce <pierce@hogranch.com>)
Re: How do you change the size of the WAL files?  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
Once again, pros and cons should be left to users discretion because one may have latest and greatest hardware and
networkresources. For example a SSD on a fiber channel on a high speed network. 


Regards,
rs

On Jan 9, 2012, at 7:06 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> Scott Marlowe <scott.marlowe@gmail.com> writes:
>> On Mon, Jan 9, 2012 at 4:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> There are tradeoffs in the other direction too, but if you feel you must
>>> have a different value, see configure's --with-wal-segsize option.  Note
>>> that you cannot change this without re-initdb.
>
>> Is there a limit to the max size?
>
> Hmm, it looks like the configure script only allows 1-64MB.  I'm not
> sure offhand if that's protecting a restriction elsewhere, or just
> not bothering to extend the switch for more cases.  Keep in mind that
> the larger you make this, the more data you can lose because it wasn't
> archived yet when your master machine failed.
>
>            regards, tom lane

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

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Re: Is there a reason why Postgres doesn't have Byte or tinyint?
Следующее
От: Дмитрий Малинин
Дата:
Сообщение: could not load library unknown error 14001