Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A3648633BC7 for ; Sun, 25 Apr 2010 04:50:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 58746-10 for ; Sun, 25 Apr 2010 07:49:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149056.authsmtp.com (outmail149056.authsmtp.com [62.13.149.56]) by mail.postgresql.org (Postfix) with ESMTP id B719B6336B3 for ; Sun, 25 Apr 2010 04:50:00 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt10.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o3P7nwBU054477; Sun, 25 Apr 2010 08:49:58 +0100 (BST) Received: from [192.168.0.2] (88-110-156-192.dynamic.dsl.as9105.com [88.110.156.192]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id o3P7nuNP059512; Sun, 25 Apr 2010 08:49:56 +0100 (BST) Subject: Re: global temporary tables From: Simon Riggs To: Robert Haas Cc: pgsql-hackers@postgresql.org In-Reply-To: References: <1272148142.4161.1598.camel@ebony> Content-Type: text/plain Date: Sun, 25 Apr 2010 08:49:55 +0100 Message-Id: <1272181795.4161.1604.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: 24703d4d-503f-11df-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagBbbElD HGQLWlREUFV7XWp/ bgwfZQ1DY0tOQQRv VlZIS1BNEQ1vHhxP WR1+VUc3CWVGfXd1 ZEQsXHJaWgp4cUF9 QRpQQXADZWQ2dWEe BBZFfgQGIh5Kfh1H bFR2U3sIYG1JBC9q VzwTFhsSEA9kHWxa RgYHJFZaXUsOBjkm TgoTVSkmF0kIXE0A X-Authentic-SMTP: 61633235383639.1014:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2 tagged_above=-10 required=5 tests=AWL=-0.100, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/1149 X-Sequence-Number: 161261 On Sat, 2010-04-24 at 19:01 -0400, Robert Haas wrote: > There is one major problem, though: assigning a > scratch relfilenode to the temporary table requires generating an OID, > which we currently have no way to allow on the standby. Why not have an unlogged counter, which resets each system start, using same datatype as an oid. There's no necessity for the relfilenode to be an actual oid is there? That way we could use it on standbys also. -- Simon Riggs www.2ndQuadrant.com