Re: Postgres insert performance and storage requirement compared to Oracle

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>, Divakar Singh <dpsmails(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Date: 2010-10-26 15:08:20
Message-ID: 770715.39613.qm@web29003.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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???

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2010-10-26 15:22:38 Re: xlog.c: WALInsertLock vs. WALWriteLock
Previous Message Tom Lane 2010-10-26 15:00:02 Re: add label to enum syntax

Browse pgsql-performance by date

  From Date Subject
Next Message Christian Elmerot 2010-10-26 15:23:34 Re: CPUs for new databases
Previous Message Scott Marlowe 2010-10-26 14:50:48 Re: CPUs for new databases