On Tue, Oct 26, 2010 at 5:54 PM, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> wrote: > The table is created with "on commit obliterate rows" option which means > that there is no need to do "truncate". The "truncate" command is a heavy > artillery. Truncating a temporary table is like shooting ducks in a duck > pond, with a howitzer. This is just not true. ON COMMIT DELETE ROWS simply arranges for a TRUNCATE to happen immediately before each commit. See PreCommit_on_commit_actions() in tablecmds.c. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
