Transaction Performance Question

From: "Rick Gigger" <rick(at)alpinenetworking(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Transaction Performance Question
Date: 2003-10-30 03:36:24
Message-ID: 008601c39e96$ff6b7020$0700a8c0@trogdor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tj 2003-10-30 04:25:39 duplicates rejected by index reports PGSQL_FATAL_ERROR
Previous Message Ken Godee 2003-10-30 03:17:07 Re: PG_RESTORE/DUMP Question