Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C66C21337B50 for ; Tue, 26 Oct 2010 12:08:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 02143-08 for ; Tue, 26 Oct 2010 15:08:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nm7-vm0.bullet.mail.ukl.yahoo.com (nm7-vm0.bullet.mail.ukl.yahoo.com [217.146.183.236]) by mail.postgresql.org (Postfix) with SMTP id A6CFE1337B2F for ; Tue, 26 Oct 2010 12:08:22 -0300 (ADT) Received: from [217.146.183.212] by nm7.bullet.mail.ukl.yahoo.com with NNFMP; 26 Oct 2010 15:08:21 -0000 Received: from [217.146.183.178] by tm5.bullet.mail.ukl.yahoo.com with NNFMP; 26 Oct 2010 15:08:21 -0000 Received: from [127.0.0.1] by omp1019.mail.ukl.yahoo.com with NNFMP; 26 Oct 2010 15:08:21 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 108142.64079.bm@omp1019.mail.ukl.yahoo.com Received: (qmail 41104 invoked by uid 60001); 26 Oct 2010 15:08:20 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1288105700; bh=OSb3r+4m3+2bi6O4sW6jeBLlzUowBaPrWG2b9ZfCREE=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=hGzPgdi2b+z+efQcYXY3gIL6b9VnrutW/UTuUEmqvYuCNTLBaGERgNNiaWfdX7Af4zq5Mxag3/7lhb30yXLUqZG2XhX1Z8kMwtVwJQt1PGA9B3iwu501ND7pLhvMY8gB2D0gVUDtf3njtoaj0EMUZx5Dv9Shg6StL88HkexyNnI= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.it; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=W0nTTWmaxZACXqVt9bZdh4esuTpnVpp+m+CjtloMRvo+6G9OHvQm3Osv59WFmovfDdoIF4I23lCCvWHYdo9rEIuw/PtUt+7d4KfZKbNIaUECa7JHomQKZZyfPWDDCOx0zIfyveJQm2wC5mtgWTjxEfl2SJsXmzSwuiO/tWQptUg=; Message-ID: <770715.39613.qm@web29003.mail.ird.yahoo.com> X-YMail-OSG: BipUG.wVM1kjVTW30mDlCzkxI.9SPb2h4oXsIoe3v7vwDfH P3f6UVbfG Received: from [151.82.78.8] by web29003.mail.ird.yahoo.com via HTTP; Tue, 26 Oct 2010 16:08:20 BST X-Mailer: YahooMailRC/504.5 YahooMailWebService/0.8.107.284920 References: <402913.53404.qm@web65405.mail.ac4.yahoo.com> <208728.42197.qm@web65409.mail.ac4.yahoo.com> Date: Tue, 26 Oct 2010 16:08:20 +0100 (BST) From: Leonardo Francalanci Subject: Re: Postgres insert performance and storage requirement compared to Oracle To: Merlin Moncure , Divakar Singh Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/438 X-Sequence-Number: 40856 > temp tables are not wal logged or=0A> synced. Periodically they can be = flushed to a permanent table.=0A=0A=0AWhat do you mean with "Periodically = they can be flushed to=0Aa permanent table"? Just doing =0A=0Ainsert into = tabb select * from temptable=0A=0Aor using a proper, per-temporary table co= mmand???=0A=0A=0A