Re: Re: Postgres insert performance and storage requirement compared to Oracle - Mailing list pgsql-performance

Robert Haas <robertmhaas@gmail.com> 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