Artiom Makarov wrote: > 2010/4/1 Bruce Momjian <bruce@xxxxxxxxxx>: > > > 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance