X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3429452851 for ; Fri, 3 Jun 2005 10:27:39 -0300 (ADT) 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 57384-08 for ; Fri, 3 Jun 2005 13:27:30 +0000 (GMT) Received: from relay.snowman.net (relay.snowman.net [66.92.160.56]) by svr1.postgresql.org (Postfix) with ESMTP id 1201652872 for ; Fri, 3 Jun 2005 10:27:29 -0300 (ADT) Received: from ns.snowman.net (ns.snowman.net [10.10.0.2]) by relay.snowman.net (8.13.1/8.13.1/Debian-19) with ESMTP id j53DRI4j003358 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Fri, 3 Jun 2005 09:27:18 -0400 Received: from ns.snowman.net (localhost [127.0.0.1]) by ns.snowman.net (8.13.4/8.13.4/Debian-2) with ESMTP id j53DRLsX026853 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Fri, 3 Jun 2005 09:27:21 -0400 Received: (from sfrost@localhost) by ns.snowman.net (8.13.4/8.13.4/Submit) id j53DRKhT026851; Fri, 3 Jun 2005 09:27:20 -0400 Date: Fri, 3 Jun 2005 09:27:20 -0400 From: Stephen Frost To: Marc Mamin Cc: pgsql-performance@postgresql.org Subject: Re: Query limitations (size, number of UNIONs ...) Message-ID: <20050603132720.GB30011@ns.snowman.net> Mail-Followup-To: Marc Mamin , pgsql-performance@postgresql.org References: <1117758630.429fa4a66825f@webmail.rawbw.com> <30384.1117780528@www35.gmx.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="hs0MrtevJDaC/yEQ" Content-Disposition: inline In-Reply-To: <30384.1117780528@www35.gmx.net> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 09:26:34 up 489 days, 8:15, 8 users, load average: 0.34, 0.35, 0.24 User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/70 X-Sequence-Number: 12708 --hs0MrtevJDaC/yEQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Marc Mamin (m.mamin@gmx.net) wrote: > I've just made a first test wich resulted in a query being 15KB big annd > containing 63 UNION. If the data is distinct from each other or you don't mind duplicate records you might try using 'union all' instead of 'union'. Just a thought. Stephen --hs0MrtevJDaC/yEQ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFCoFq4rzgMPqB3kigRAnxrAKCN7D/pVpVt7SBJln7+8tO4ihiswQCdFQzu stx3eWWzw0ivbgRhPPX8n9k= =1cxA -----END PGP SIGNATURE----- --hs0MrtevJDaC/yEQ--