Re: Transactions and temp tables

From: Emmanuel Cecchet <manu(at)frogthinker(dot)org>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transactions and temp tables
Date: 2008-12-08 19:47:12
Message-ID: 493D79C0.7080405@frogthinker.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Here is a new version of the patch still based on the last proposal by
Heikki.
This patch only support temp tables that are created AND dropped in the
same transaction. This works with any kind of temp table (with on commit
options or not).
This simplifies the problem since the temp tables we consider here
cannot be accessed by another backend anyway since their scope is the
one of the transaction.
We do NOT allow:
- access to temp tables that were not created AND dropped in the transaction
- created temp tables that are not dropped at prepare time
- dropped temp tables that were not created in the transaction

The attached patch has a number of tests for all these cases including
sequences and index on temp tables.

Let me know what you think
Emmanuel

--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu(at)frogthinker(dot)org
Skype: emmanuel_cecchet

Attachment Content-Type Size
patch-2pc-temp-table-8.4v6-create_drop_only-withtests.zip application/octet-stream 9.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-12-08 20:20:34 Re: new vacuum is slower for small tables
Previous Message Simon Riggs 2008-12-08 19:00:52 Re: Updates of SE-PostgreSQL 8.4devel patches (r1268)