Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 04730632291 for ; Mon, 30 Aug 2010 04:59:09 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 95874-02 for ; Mon, 30 Aug 2010 07:59:01 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fep12.mx.upcmail.net (fep12.mx.upcmail.net [62.179.121.32]) by mail.postgresql.org (Postfix) with ESMTP id 6E43063226D for ; Mon, 30 Aug 2010 04:59:01 -0300 (ADT) Received: from edge05.upcmail.net ([192.168.13.212]) by viefep12-int.chello.at (InterMail vM.8.01.02.02 201-2260-120-106-20100312) with ESMTP id <20100830075859.DBCZ8780.viefep12-int.chello.at@edge05.upcmail.net>; Mon, 30 Aug 2010 09:58:59 +0200 Received: from wiesinger.com ([84.112.167.138]) by edge05.upcmail.net with edge id 0Xyx1f05Z2zVakc05Xyypc; Mon, 30 Aug 2010 09:58:59 +0200 X-SourceIP: 84.112.167.138 Received: from bbs.intern (localhost [127.0.0.1]) by wiesinger.com (8.14.4/8.14.4) with ESMTP id o7U7wFaM021494; Mon, 30 Aug 2010 09:58:15 +0200 Received: from localhost (gerhard@localhost) by bbs.intern (8.14.4/8.14.4/Submit) with ESMTP id o7U7wFm8021490; Mon, 30 Aug 2010 09:58:15 +0200 Date: Mon, 30 Aug 2010 09:58:15 +0200 (CEST) From: Gerhard Wiesinger To: Pavel Stehule cc: Andreas Kretschmer , pgsql-performance@postgresql.org Subject: Re: Major performance problem after upgrade from 8.3 to 8.4 In-Reply-To: Message-ID: References: <20100830072230.GA28373@tux> User-Agent: Alpine 2.01 (LFD 1266 2009-07-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-MailScanner-Information-wiesinger-com: Please contact the ISP for more information X-wiesinger-com-MailScanner-ID: o7U7wFaM021494 X-MailScanner-wiesinger-com: Found to be clean X-MailScanner-SpamCheck-wiesinger-com: not spam, SpamAssassin (not cached, score=-4.399, required 4.5, autolearn=not spam, ALL_TRUSTED -1.80, BAYES_00 -2.60) X-MailScanner-From: lists@wiesinger.com X-Cloudmark-Analysis: v=1.1 cv=Q5sYvte7CdFO72xZDcMRKl084a5I42uXcYDcqm+r+xQ= c=1 sm=0 a=-BBt41PQAQkA:10 a=ORa4HqFjfvEA:10 a=kj9zAlcOel0A:10 a=ZqxAMWuMAAAA:8 a=-ProOGmuAAAA:8 a=f62ZOjPa5hR2DPcXjVcA:9 a=UjdjAJyEWrXqvekOTRoA:7 a=OA9DueYE7IgBu9NmBuw8X3efLRIA:4 a=CjuIK1q_8ugA:10 a=25N3bAZzUGoA:10 a=fU-A4pz3-wIA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-10 required=5 tests=BAYES_05=-0.5, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/317 X-Sequence-Number: 40160 On Mon, 30 Aug 2010, Pavel Stehule wrote: > Hello > > 2010/8/30 Andreas Kretschmer : >> Gerhard Wiesinger wrote: >> >>> I know that the data model is key/value pairs but it worked well in 8.3. >>> I need this flexibility. >>> >>> Any ideas? >> >> If i understand the query correctly it's a pivot-table, right? >> > > no - it's just EAV table on very large data :( Yes, it is an EAV table, but with query space comparable low (Max. 1 day out of years, typically 5mins out of years). Thnx. Ciao, Gerhard -- http://www.wiesinger.com/