Re: Temporary tables and disk activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary tables and disk activity
Date: 2004-12-13 22:24:56
Message-ID: 28666.1102976696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2004-12-13 22:32:15 Re: Possible dump/restore bug
Previous Message Tom Lane 2004-12-13 22:12:19 Re: Possible dump/restore bug