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 21F1552854 for ; Fri, 20 May 2005 16:57:41 -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 72919-10 for ; Fri, 20 May 2005 19:57:32 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id 910FF52844 for ; Fri, 20 May 2005 16:57:31 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id A14002B4; Fri, 20 May 2005 15:57:52 -0400 From: "Joel Fradkin" To: "PostgreSQL Perform" Subject: cant seem to post the explain Date: Fri, 20 May 2005 15:58:29 -0400 Message-ID: <006e01c55d76$4adf27f0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006F_01C55D54.C3CD87F0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.051 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200505/333 X-Sequence-Number: 12497 This is a multi-part message in MIME format. ------=_NextPart_000_006F_01C55D54.C3CD87F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sorry I tried a few times to break this email up (guess there must be a = size limit?). Any one interested in seeing the explain for the speed of many group = by's question just email me. =20 Basically the sql is built by a dynamic cube product from data dynamics. I can edit it prior to it running, but it runs very slow even off the flattened file. I am guessing the product needs the data from the sql I supplied in = previous post. =20 I don't have any ideas to speed it up as I cant store an aggregate flat table without updating it when updates and inserts are made and that = would be too time consuming. Any ideas for how to approach getting the same data set in a faster = manner are greatly appreciated. =20 Joel Fradkin =20 =20 ------=_NextPart_000_006F_01C55D54.C3CD87F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Sorry I tried a few times to break this email up = (guess there must be a size limit?).

Any one interested in seeing the explain for the = speed of many group by’s question just email me.

 

Basically the sql is built by a dynamic cube product = from data dynamics.

I can edit it prior to it running, but it runs very = slow even off the flattened file.

I am guessing the product needs the data from the sql = I supplied in previous post.

 

I don’t have any ideas to speed it up as I cant = store an aggregate flat table without updating it when updates and inserts are = made and that would be too time consuming.

Any ideas for how to approach getting the same data = set in a faster manner are greatly appreciated.

 

Joel Fradkin

 

 

------=_NextPart_000_006F_01C55D54.C3CD87F0--