From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: high transaction rate |
Date: | 2016-12-07 16:58:50 |
Message-ID: | ce503a96-f7e1-e1f7-e906-e04b2c443161@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/7/2016 8:47 AM, Rob Sargent wrote:
> Please tell me that in this case, updating 2 (big)integer columns does
> not generate dead tuples (i.e. does not involve a insert/delete pair).
if the fields being updated aren't indexed, and there's free tuple space
that has already been vacuumed in the same block, then the update is
done via "HOT" (or is it HEAT?) within the same block... but with 1000s
of updates per second to the same 500 rows ? odds of autovacuum keeping
up are sketchy.. otherwise, all updates are insert/delete operations
due to the requirements of MVCC
a SQL database may not really be the best way to do what you're
doing. an array of your 500 rows, updated in memory, with updates
logged to a transaction file and the whole array periodically written to
disk, would very likely be MUCH higher performance..
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Brenner | 2016-12-07 18:58:56 | Re: [GENERAL] Select works only when connected from login postgres |
Previous Message | Rob Sargent | 2016-12-07 16:47:21 | Re: high transaction rate |