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? PS I see a workaround: switch off "on commit delete rows" on temp tables and use txid_current() to control transaction visibility. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance