From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Rick Gigger <rick(at)alpinenetworking(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transaction Performance Question |
Date: | 2003-10-30 14:52:22 |
Message-ID: | Pine.LNX.4.33.0310300747310.23153-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 29 Oct 2003, Rick Gigger wrote:
> In the following situation:
>
> You do a large transaction where lots of rows are update
> All of your tables/indexes cached in memory
>
> When are the updated rows written out to disk? When they are updated inside
> the transaction, or when the transaction is completed?
The data is written out but not made real, so to speak, during each
update. I.e. the updates individually add all these rows. At the end of
the transaction, if we rollback, all the tuples that were written out are
simply not committed, and therefore the last version of that record
remains the last one in the chain.
If the transaction is committed then each tuple becomes the last in its
chain (could it be second to last because of other transactions? I'm not
sure.)
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-10-30 15:06:59 | Re: slow query performance |
Previous Message | Ken Guest | 2003-10-30 14:51:32 | formatting of SQL sent by PHP to postgres |