Re: Decreasing WAL size effects

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Decreasing WAL size effects
Дата
Msg-id 4907FF00.4040008@commandprompt.com
обсуждение исходный текст
Ответ на Decreasing WAL size effects  (Jason Long <mailing.list@supernovasoftware.com>)
Список pgsql-general
Jason Long wrote:
> I am planning on setting up PITR for my application.

> I also have to ship them off site using a T1 so setting the time to
> automatically switch files will just waste bandwidth if they are still
> going to be 16 MB anyway.
>
> *1.  What is the effect of recompiling and reducing the default size of
> the WAL files?

Increased I/O

> 2.  What is the minimum suggested size?

16 megs, the default.

> 3.  If I reduce the size how will this work if I try to save a document
> that is larger than the WAL size?

You will create more segments.

Joshua D. Drake

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Problem with sql
Следующее
От: "Ravi Chemudugunta"
Дата:
Сообщение: using plpgsql debuggers