Re: Locks on temp table and PREPARE

Поиск
Список
Период
Сортировка
От Emmanuel Cecchet
Тема Re: Locks on temp table and PREPARE
Дата
Msg-id 4A26F700.7010205@frogthinker.org
обсуждение исходный текст
Ответ на Re: Locks on temp table and PREPARE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeremy Kerr
Дата:
Сообщение: Re: [PATCH v2] Add bit operations util header
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Plan time Improvement - 64bit bitmapset