Postgres Pro
Downloads
Home   >   mailing lists

Re: temp table "on commit delete rows": transaction overhead - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: temp table "on commit delete rows": transaction overhead
Date
Msg-id 201004051209.o35C9MB10324@momjian.us
Whole thread Raw
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Using high speed swap to improve performance?
Next
From: Oliver Kindernay
Date:
Subject: Huge table searching optimization