Re: Locks on temp table and PREPARE - Mailing list pgsql-hackers

From Emmanuel Cecchet
Subject Re: Locks on temp table and PREPARE
Date
Msg-id 4A26F700.7010205@frogthinker.org
Whole thread Raw
In response to Re: Locks on temp table and PREPARE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Emmanuel Cecchet <manu@frogthinker.org> writes:
>   
>> But when the transaction prepares, we know that. What would prevent us 
>> to do at prepare time the same cleanup that commit does?
>>     
>
> The entire point of PREPARE is that it's *not* committed yet.
>   
Agreed but all objects that were created and dropped in the transaction 
are going to be cleaned up whether the transaction commits or rollbacks. 
It seems that releasing these resources at PREPARE time would help for 
these 'temporary' objects that only have a transaction scope, right?
                     regards, manu


pgsql-hackers by date:

Previous
From: Jeremy Kerr
Date:
Subject: Re: [PATCH v2] Add bit operations util header
Next
From: Robert Haas
Date:
Subject: Re: Plan time Improvement - 64bit bitmapset