X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B578F4759AF for ; Sun, 16 Feb 2003 03:19:45 -0500 (EST) Received: from mail.idea.net.pl (smtp-in.centertel.pl [194.9.223.7]) by postgresql.org (Postfix) with ESMTP id 06E8247592C for ; Sun, 16 Feb 2003 03:19:44 -0500 (EST) Received: from skorupa (vb145.neoplus.adsl.tpnet.pl [80.50.229.145]) by mta1.centertel.pl (iPlanet Messaging Server 5.2 (built Feb 21 2002)) with ESMTPA id <0HAE0035P71YP8@mta1.centertel.pl> for pgsql-performance@postgresql.org; Sun, 16 Feb 2003 09:17:58 +0100 (CET) Date: Sun, 16 Feb 2003 09:19:06 +0100 From: Mariusz =?iso-8859-2?q?Czu=B3ada?= Subject: Re: Views with unions In-reply-to: <200302151954.33740.josh@agliodbs.com> To: Josh Berkus , pgsql-performance@postgresql.org Message-id: <200302160919.07970.manieq@idea.net.pl> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-2 Content-transfer-encoding: quoted-printable Content-disposition: inline User-Agent: KMail/1.6.1-cool References: <200302160048.14681.manieq@idea.net.pl> <200302151954.33740.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/97 X-Sequence-Number: 1153 Hi, Dnia nie 16. lutego 2003 04:54, Josh Berkus napisa=B3: > > What version of PostgreSQL are you using? UNION views optimized extreme= ly > poorly through 7.2.4; things have been improved in 7.3 PostgreSQL 7.3 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.2 (self= =20 compiled on SunBlade 100). Mariusz