Transaction Performance Question - Mailing list pgsql-general

From Rick Gigger
Subject Transaction Performance Question
Date
Msg-id 008601c39e96$ff6b7020$0700a8c0@trogdor
Whole thread Raw
In response to PG_RESTORE/DUMP Question  (Alex <alex@meerkatsoft.com>)
Responses Re: Transaction Performance Question
List pgsql-general
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?


pgsql-general by date:

Previous
From: Ken Godee
Date:
Subject: Re: PG_RESTORE/DUMP Question
Next
From: Daniel Demacek
Date:
Subject: nextgencms