Robert Haas <robertmhaas@xxxxxxxxx> writes: > Gee, I wonder if it would possible for PG to automatically do an > asynchronous commit of any transaction which touches only temp tables. Hmm ... do we need a commit at all in such a case? If our XID has only gone into temp tables, I think we need to write to clog, but we don't really need a WAL entry, synced or otherwise. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance