Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E27FB633140 for ; Tue, 25 May 2010 07:42:12 -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 56445-05 for ; Tue, 25 May 2010 10:42:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id CA1156338A8 for ; Tue, 25 May 2010 07:42:05 -0300 (ADT) Received: from alap2.localnet (p579FA6C9.dip.t-dialin.net [87.159.166.201]) by mail.anarazel.de (Postfix) with ESMTPSA id 68E7B448004; Tue, 25 May 2010 12:42:02 +0200 (CEST) From: Andres Freund To: pgsql-performance@postgresql.org Subject: Re: performance of temporary vs. regular tables Date: Tue, 25 May 2010 12:41:58 +0200 User-Agent: KMail/1.13.2 (Linux/2.6.34-rc5-andres-00142-g33eaf78; KDE/4.4.2; x86_64; ; ) Cc: Joachim Worringen , Grzegorz =?utf-8?q?Ja=C5=9Bkiewicz?= References: <4BFB837C.6010005@iathh.de> <4BFB91A8.20805@iathh.de> In-Reply-To: <4BFB91A8.20805@iathh.de> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Message-Id: <201005251241.59605.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/175 X-Sequence-Number: 38759 On Tuesday 25 May 2010 11:00:24 Joachim Worringen wrote: > Am 25.05.2010 10:49, schrieb Grzegorz Ja=C5=9Bkiewicz: > > temporary tables are handled pretty much like the regular table. The > > magic happens on schema level, new schema is setup for connection, so > > that it can access its own temporary tables. > > Temporary tables also are not autovacuumed. > > And that's pretty much the most of the differences. >=20 > 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=20 overhead perspective. Andres