Re: Commit(?) overhead

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Duncan Kinnear <duncan(dot)kinnear(at)mccarthy(dot)co(dot)nz>, Andres Freund <andres(at)anarazel(dot)de>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "pgsql-performa(dot)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Commit(?) overhead
Date: 2019-04-10 08:16:50
Message-ID: 31aae195b068ceeafc50a9ae4a5f5247a81f0d84.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Kretschmer 2019-04-10 08:20:58 Re: PostgreSQL upgrade.
Previous Message Daulat Ram 2019-04-10 05:40:25 PostgreSQL upgrade.