Обсуждение: Re: temp table "on commit delete rows": transaction overhead

Поиск
Список
Период
Сортировка

Re: temp table "on commit delete rows": transaction overhead

От
Bruce Momjian
Дата:
Artiom Makarov wrote:
> 2010/4/1 Bruce Momjian <bruce@momjian.us>:
>
> > I think one of the problems is that we do the truncate even if the table
> > has not be touched by the query, which is poor behavior.
>
> Thank you for the support.
> Will be this problem registered?

I have it on my personal TODO and will try to get it on the official
TODO soon.

> I see a workaround: switch off "on commit delete rows" on temp tables
> and use txid_current() to control transaction visibility.

OK.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com