Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A634763287B for ; Wed, 26 May 2010 13:03:26 -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 28782-02 for ; Wed, 26 May 2010 16:03:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www64.your-server.de (www64.your-server.de [213.133.104.64]) by mail.postgresql.org (Postfix) with ESMTP id 7BC8F6325EF for ; Wed, 26 May 2010 13:03:19 -0300 (ADT) Received: from [78.46.5.203] (helo=sslproxy01.your-server.de) by www64.your-server.de with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1OHJ4f-0000ba-TW; Wed, 26 May 2010 18:03:17 +0200 Received: from [217.89.104.238] (helo=lisa.local.iathh.de) by sslproxy01.your-server.de with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1OHJXv-0000Gq-6s; Wed, 26 May 2010 18:33:31 +0200 Received: from [192.168.10.81] ([192.168.10.81]) (authenticated user joachim.worringen@iathh.de) by lisa.local.iathh.de (Kerio MailServer 6.7.3 patch 1); Wed, 26 May 2010 18:03:04 +0200 Message-ID: <4BFD4643.9010901@iathh.de> Date: Wed, 26 May 2010 18:03:15 +0200 From: Joachim Worringen Organization: IAT GmbH User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: Andres Freund CC: pgsql-performance@postgresql.org, =?UTF-8?B?R3J6ZWdvcnogSmHFm2tpZXdpYw==?= =?UTF-8?B?eg==?= Subject: Re: performance of temporary vs. regular tables References: <4BFB837C.6010005@iathh.de> <4BFB91A8.20805@iathh.de> <201005251241.59605.andres@anarazel.de> In-Reply-To: <201005251241.59605.andres@anarazel.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Authenticated-Sender: office@iathh.de X-Virus-Scanned: Clear (ClamAV 0.96/11084/Wed May 26 12:57:11 2010) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201005/198 X-Sequence-Number: 38782 Am 25.05.2010 12:41, schrieb Andres Freund: > On Tuesday 25 May 2010 11:00:24 Joachim Worringen wrote: >> Thanks. So, the Write-Ahead-Logging (being used or not) does not matter? > It does matter quite significantly in my experience. Both from an io and a cpu > overhead perspective. O.k., looks as if I have to make my own experience... I'll let you know if possible. Joachim