X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 08B26474E61 for ; Sat, 15 Feb 2003 22:55:20 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 5FF79474E42 for ; Sat, 15 Feb 2003 22:55:19 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2842191; Sat, 15 Feb 2003 19:55:20 -0800 Content-Type: text/plain; charset="iso-8859-2" From: Josh Berkus Organization: Aglio Database Solutions To: Mariusz =?iso-8859-2?q?Czu=B3ada?= , pgsql-performance@postgresql.org Subject: Re: Views with unions Date: Sat, 15 Feb 2003 19:54:33 -0800 User-Agent: KMail/1.4.3 References: <200302160048.14681.manieq@idea.net.pl> In-Reply-To: <200302160048.14681.manieq@idea.net.pl> MIME-Version: 1.0 Message-Id: <200302151954.33740.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/96 X-Sequence-Number: 1152 Mariusz, > While testing multi-select views I found some problems. Here are details.= I > have 3 tables and I created a view on them: What version of PostgreSQL are you using? UNION views optimized extremely= =20 poorly through 7.2.4; things have been improved in 7.3 --=20 Josh Berkus Aglio Database Solutions San Francisco