Re: Why Wal_buffer is 64KB

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Why Wal_buffer is 64KB
Дата
Msg-id dcc563d11003282345w6d3e7adbh6458b0f5a7c3d4a6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why Wal_buffer is 64KB  (Tadipathri Raghu <traghu.dba@gmail.com>)
Ответы Re: Why Wal_buffer is 64KB  (Tadipathri Raghu <traghu.dba@gmail.com>)
Список pgsql-performance
On Mon, Mar 29, 2010 at 12:00 AM, Tadipathri Raghu <traghu.dba@gmail.com> wrote:
> Hi All,
>
> Thank you for all the support.
>
> I have noticed one more thing here, that if you turn off the fsync and try
> to run the transaction than its breaking the currnet filenode and generating
> another filenode. Is it true that whenever you turn off or on the fsync the
> filenode will break and create one more on that table.

From what I understand, with fsync on or off the same stuff gets
written.  It's just not guaranteed to go out in the right order or
right now, but eventually.

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

Предыдущее
От: Tadipathri Raghu
Дата:
Сообщение: Re: Why Wal_buffer is 64KB
Следующее
От: Tadipathri Raghu
Дата:
Сообщение: Re: Why Wal_buffer is 64KB