Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 467E89FBE5B for ; Tue, 3 Jul 2007 06:24:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 91520-04 for ; Tue, 3 Jul 2007 06:24:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [87.127.95.194]) by postgresql.org (Postfix) with ESMTP id 3FA119FBE39 for ; Tue, 3 Jul 2007 06:24:48 -0300 (ADT) Received: from localhost.enta.net ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1I5ecb-0001ZO-EM; Tue, 03 Jul 2007 10:24:33 +0100 From: Gregory Stark To: "Pavel Stehule" Cc: "Jaime Casanova" , "Alvaro Herrera" , "Tom Lane" , "Jim Nasby" , "PostgreSQL-development" Subject: Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL In-Reply-To: <162867790707022208w267d43aard8ee2dabc219bb38@mail.gmail.com> (Pavel Stehule's message of "Tue, 3 Jul 2007 07:08:36 +0200") Organization: EnterpriseDB References: <162867790707011431u71e53543x19e64e5bb160b124@mail.gmail.com> <17505.1183326406@sss.pgh.pa.us> <19689F96-2FE1-4343-BE86-94317AEB0C57@decibel.org> <19728.1183394601@sss.pgh.pa.us> <20070703004634.GB4757@alvh.no-ip.org> <87d4za5jsg.fsf@oxford.xeocode.com> <162867790707022208w267d43aard8ee2dabc219bb38@mail.gmail.com> X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX" 24805) Date: Tue, 03 Jul 2007 10:24:33 +0100 Message-ID: <878x9x6dri.fsf@oxford.xeocode.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/59 X-Sequence-Number: 104974 "Pavel Stehule" writes: > Global temp table can be created from template only when is used. It's > has not negative efect on app which doesn't use it. The benefit of > g.t.t. is simplifycation of stored procedures. And if it's used in 200 txns/s? Imagine the earlier poster who was looking for a way to display the count of records matching a search followed by the ten records on the page without re-executing the search. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com