Re: 8.3 synchronous_commit
От
Fernando Ike
Тема
Re: 8.3 synchronous_commit
Дата
Msg-id
20080121224821.22c2a800@pmanson
Ответ на
Re: 8.3 synchronous_commit (Jeff Davis)
Список
Дерево обсуждения
8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
Re: 8.3 synchronous_commit Jeff Davis <pgsql@j-davis.com>
Re: 8.3 synchronous_commit "Pavel Stehule" <pavel.stehule@gmail.com>
Re: 8.3 synchronous_commit Florian Weimer <fweimer@bfk.de>
Re: 8.3 synchronous_commit "Guillaume Smet" <guillaume.smet@gmail.com>
Re: 8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
Re: 8.3 synchronous_commit Florian Weimer <fweimer@bfk.de>
Re: 8.3 synchronous_commit Greg Smith <gsmith@gregsmith.com>
Re: 8.3 synchronous_commit Jeff Davis <pgsql@j-davis.com>
Re: 8.3 synchronous_commit Fernando Ike <fike@midstorm.org>
Re: 8.3 synchronous_commit Greg Smith <gsmith@gregsmith.com>
Re: 8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
Em Mon, 21 Jan 2008 15:45:54 -0800 Jeff Davis escreveu: > On Mon, 2008-01-21 at 18:31 -0500, Greg Smith wrote: > > pgbench doesn't handle 100 clients at once very well on the same > > box as the server, unless you have a pretty serious system. The > > pgbench program itself has a single process model that doesn't > > handle the CFQ round-robin very well at all. On top of that, the > > database scale should be bigger > > He was referring to the CFQ I/O scheduler. I don't think that will > affect pgbench itself, because it doesn't read/write to disk, right? > No. But pgbench local running, it will be concurrency with PostgreSQL. I'm realized some test and really confirm disable *synchronous_commit* performance degrade with CFQ and Deadline. Kind Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog
В списке pgsql-performance по дате отправления
