On Tue, Oct 26, 2010 at 6:50 PM, Robert Haas <[email protected]> wrote: > On Tue, Oct 26, 2010 at 5:54 PM, Mladen Gogala > <[email protected]> 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.
quite so. If you are doing anything performance sensitive with 'on commit drop', you are better off organizing a cache around txid_current() (now(), pid for older pg versions). Skips the writes to the system catalogs and truncate. merlin -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
