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

From Leonardo Francalanci
Subject Re: Postgres insert performance and storage requirement compared to Oracle
Date
Msg-id 770715.39613.qm@web29003.mail.ird.yahoo.com
Whole thread Raw
In response to Re: Postgres insert performance and storage requirement compared to Oracle  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Postgres insert performance and storage requirement compared to Oracle
List pgsql-performance
> 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 permanent table"? Just doing

insert into tabb select * from temptable

or using a proper, per-temporary table command???




pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: CPUs for new databases
Next
From: Christian Elmerot
Date:
Subject: Re: CPUs for new databases