Re: [PERFORM] Re: Postgres insert performance and storage requirement compared to Oracle

2010-10-27 Thread Tom Lane
Robert Haas 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 d

Re: [PERFORM] Re: Postgres insert performance and storage requirement compared to Oracle

2010-10-27 Thread Robert Haas
On Wed, Oct 27, 2010 at 6:13 AM, Ivan Voras wrote: > On 10/26/10 17:41, Merlin Moncure wrote: >> On Tue, Oct 26, 2010 at 11:08 AM, Leonardo Francalanci >> wrote: temp  tables are not wal logged or synced.  Periodically they can be flushed  to a permanent table. >>> >>> >>> What do you

Re: [PERFORM] Re: Postgres insert performance and storage requirement compared to Oracle

2010-10-27 Thread Merlin Moncure
On Wed, Oct 27, 2010 at 6:13 AM, Ivan Voras wrote: > On 10/26/10 17:41, Merlin Moncure wrote: >> On Tue, Oct 26, 2010 at 11:08 AM, Leonardo Francalanci >> wrote: temp  tables are not wal logged or synced.  Periodically they can be flushed  to a permanent table. >>> >>> >>> What do you

[PERFORM] Re: Postgres insert performance and storage requirement compared to Oracle

2010-10-27 Thread Ivan Voras
On 10/26/10 17:41, Merlin Moncure wrote: > On Tue, Oct 26, 2010 at 11:08 AM, Leonardo Francalanci > wrote: >>> temp tables are not wal logged or >>> synced. Periodically they can be flushed to a permanent table. >> >> >> What do you mean with "Periodically they can be flushed to >> a permanen