Re: Temporary tables and disk activity - Mailing list pgsql-general

From Tom Lane
Subject Re: Temporary tables and disk activity
Date
Msg-id 28666.1102976696@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary tables and disk activity  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
List pgsql-general
Phil Endecott <spam_from_postgresql_general@chezphil.org> writes:
> What would happen if I were to rollback at the end of the transaction,
> rather than committing (having made no changes)?  Would that eliminate
> some or all of the catalog writes?

It would avoid fsync'ing the changes at commit time, but not really
reduce the write volume per se.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible dump/restore bug
Next
From: William Yu
Date:
Subject: Re: Possible dump/restore bug