disk writes within a transaction

From: 2xlp - ListSubscriptions <postgres(at)2xlp(dot)com>
To: pgsql-general general <pgsql-general(at)postgresql(dot)org>
Subject: disk writes within a transaction
Date: 2017-02-16 19:33:13
Message-ID: 81F0A30F-0912-4FD0-B496-C79167B1DD4A@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can someone enlighten me to how postgres handles disk writing? I've read some generic remarks about buffers, but that's about it.

We have a chunk of code that calls Postgres in a less-than-optimal way within a transaction block. I'm wondering where to prioritize fixing it, as the traffic on the wire isn't an issue.

Basically the code looks like this:

begin;
update foo set foo.a='1' where foo.bar = 1;
...
update foo set foo.b='2' where foo.bar = 1;
...
update foo set foo.c='3' where foo.bar = 1;
commit;

If the updates are likely to be a memory based operation, consolidating them can wait. If they are likely to hit the disk, I should schedule refactoring this code sooner than later.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-02-16 20:10:08 Re: disk writes within a transaction
Previous Message Tom Lane 2017-02-16 19:14:41 Re: application generated an eternal block in the database