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

От: Bruce Momjian
Тема: Re: temp table "on commit delete rows": transaction overhead
Дата: ,
Msg-id: 201004051209.o35C9MB10324@momjian.us
(см: обсуждение, исходный текст)
Список: pgsql-performance

Artiom Makarov wrote:
> 2010/4/1 Bruce Momjian <>:
>
> > 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  <>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com


В списке pgsql-performance по дате сообщения:

От: Oliver Kindernay
Дата:
Сообщение: Re: Huge table searching optimization
От: Brian Cox
Дата:
Сообщение: query slow; strace output worrisome