Re: 8.1 Release Candidate 1 Bundled ...

Hi,

On Sun, 30 Oct 2005, Marc G. Fournier wrote:

> Take a look through it, will announce this evening ...

Could you please include RPMs in your announcement? They *will* be here:

http://developer.postgresql.org/~devrim/rpms/8.1/rc1

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-hackers-owner(at)postgresql(dot)org Sun Oct 30 06:34:51 2005
X-Original-To: pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 94707DB3AE
for <pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sun, 30 Oct 2005 06:34:50 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 18217-05
for <pgsql-hackers-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Sun, 30 Oct 2005 10:34:48 +0000 (GMT)
Received: from mail.nederland.net (mail.nederland.net [83.137.20.15])
by svr1.postgresql.org (Postfix) with ESMTP id 3CEA8DB3AD
for <pgsql-hackers(at)postgresql(dot)org>; Sun, 30 Oct 2005 06:34:49 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
by romeo.computel.nl (Postfix) with ESMTP id D63C9141E9;
Sun, 30 Oct 2005 11:34:51 +0100 (CET)
Received: from mail.nederland.net ([127.0.0.1])
by localhost (romeo.computel.nl [127.0.0.1]) (amavisd-new, port 10024)
with ESMTP id 06056-03; Sun, 30 Oct 2005 11:34:51 +0100 (CET)
Received: from balefirehome (balefire.demon.nl [212.238.240.59])
by romeo.computel.nl (Postfix) with ESMTP id 0FB70141E8;
Sun, 30 Oct 2005 11:34:50 +0100 (CET)
Message-ID: <002001c5dd3d$928d3b40$64c8a8c0(at)balefirehome>
From: "Sander Steffann" <steffann(at)nederland(dot)net>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>,
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <josh(at)agliodbs(dot)com>,
"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
References: <200510281734(dot)11285(dot)josh(at)agliodbs(dot)com> <7702(dot)1130560067(at)sss(dot)pgh(dot)pa(dot)us> <001f01c5dc87$e81a2390$64c8a8c0(at)balefirehome> <20051029131313(dot)GD17490(at)svana(dot)org> <11787(dot)1130607762(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: FKs on temp tables: hard, or just omitted?
Date: Sun, 30 Oct 2005 11:34:56 +0100
Organization: Computel Standby BV
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="Windows-1252";
reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.023 required=5 tests=[AWL=0.023]
X-Spam-Score: 0.023
X-Spam-Level:
X-Archive-Number: 200510/1371
X-Sequence-Number: 75230

Hi,

> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
>> You solve it by allowing other backends to lock and examine your
>> temporary tables. But AIUI temporary tables are not stored in shared
>> memory so how do you get a consistant view of it?
>
>> Not unsolvable, but very tricky.
>
> Right, the problem isn't that "it can't be done", it's that "it can't be
> done without giving up most of the performance advantages of temp tables".
> Which seems like a bad tradeoff, at least to me ...

Ah, now I understand the problem :-)

And I think you are right. It would be a very bad tradeoff.
Sander