pgsql: Skip truncating ON COMMIT DELETE ROWS temp tables, if the transa

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Skip truncating ON COMMIT DELETE ROWS temp tables, if the transa
Date: 2013-01-29 08:44:57
Message-ID: E1U06oL-0006tQ-Mw@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Skip truncating ON COMMIT DELETE ROWS temp tables, if the transaction hasn't
touched any temporary tables.

We could try harder, and keep track of whether we've inserted to any temp
tables, rather than accessed them, and which temp tables have been inserted
to. But this is dead simple, and already covers many interesting scenarios.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c9d7dbacd387ab3814bc6b38010a9e72a02ea4f5

Modified Files
--------------
src/backend/commands/tablecmds.c | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-01-29 10:11:14 pgsql: Allow pgbench to use a scale larger than 21474.
Previous Message Simon Riggs 2013-01-29 00:07:13 pgsql: Fast promote mode skips checkpoint at end of recovery.