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 31D3B52867 for ; Fri, 3 Jun 2005 03:35:44 -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 53821-05 for ; Fri, 3 Jun 2005 06:35:33 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id E116052806 for ; Fri, 3 Jun 2005 03:35:28 -0300 (ADT) Received: (qmail 1073 invoked by uid 0); 3 Jun 2005 06:35:28 -0000 Received: from 217.17.202.254 by www35.gmx.net with HTTP; Fri, 3 Jun 2005 08:35:28 +0200 (MEST) Date: Fri, 3 Jun 2005 08:35:28 +0200 (MEST) From: "Marc Mamin" To: pgsql-performance@postgresql.org MIME-Version: 1.0 References: <1117758630.429fa4a66825f@webmail.rawbw.com> Subject: Query limitations (size, number of UNIONs ...) X-Priority: 3 (Normal) X-Authenticated: #3793498 Message-ID: <30384.1117780528@www35.gmx.net> X-Mailer: WWW-Mail 1.6 (Global Message Exchange) X-Flags: 0001 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/59 X-Sequence-Number: 12697 Hello, I've split my data in daily tables to keep them in an acceptable size. Now I have quite complex queries which may be very long if I need to query a large number of daily tables. I've just made a first test wich resulted in a query being 15KB big annd containing 63 UNION. The Query plan in PGAdmin is about 100KB big with 800 lines :-) The performance is not such bad, but I'm wondering if there are some POSTGRES limitations I should take care of with this strategy. Thanks, Marc -- Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis ++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++