On Tue, Oct 26, 2010 at 5:54 PM, Mladen Gogala <mladen.gog...@vmsinfo.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
