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 по дате отправления: