Re: Commit(?) overhead
От
Laurenz Albe
Тема
Re: Commit(?) overhead
Дата
Msg-id
31aae195b068ceeafc50a9ae4a5f5247a81f0d84.camel@cybertec.at
Ответ на
Re: Commit(?) overhead (Duncan Kinnear)
Список
Дерево обсуждения
Commit(?) overhead Duncan Kinnear <duncan.kinnear@mccarthy.co.nz>
Re: Commit(?) overhead Jeff Janes <jeff.janes@gmail.com>
Re: Commit(?) overhead Duncan Kinnear <duncan.kinnear@mccarthy.co.nz>
Re: Commit(?) overhead Justin Pryzby <pryzby@telsasoft.com>
Re: Commit(?) overhead Andres Freund <andres@anarazel.de>
Re: Commit(?) overhead Duncan Kinnear <duncan.kinnear@mccarthy.co.nz>
Re: Commit(?) overhead Laurenz Albe <laurenz.albe@cybertec.at>
Duncan Kinnear wrote: > Bingo! Adding 'SET LOCAL synchronous_commit TO OFF;' to my 'BEGIN; UPDATE ....; COMMIT;' > block has given me sub-1ms timings! Thanks Andres. That's a pretty clear indication that your I/O subsystem was overloaded. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-performance по дате отправления
