Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Дата
Msg-id AANLkTi=zPWqny3gSXf5yiyxh2RKO8fqGYkyPpj901ZSi@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Список pgsql-performance
On Mon, Nov 8, 2010 at 20:40, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The latter choice is the one that requires testing to prove that it is the proper and preferred default from the
performanceand data reliability POV. 
>
> And, in fact, the game plan is to do that testing and see which default
> we want.  I think it's premature to argue further about this until we
> have some test results.

Who will be doing that testing? You said you're relying on Greg Smith
to manage the testing, but he's obviously uninterested, so it seems
unlikely that this will go anywhere.

I posted my results with the simple INSERT test, but nobody cared. I
could do some pgbench runs, but I have no idea what parameters would
give useful results.

Meanwhile, PostgreSQL performance is regressing and there's still no
evidence that open_datasync is any safer.

Regards,
Marti

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: temporary tables, indexes, and query plans
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?