From: Joel Fradkin <jfradkin@wazagua.com>
To: PostgreSQL Perform <pgsql-performance@postgresql.org>
Subject: cant seem to post the explain
Date: Fri, 20 May 2005 15:58:29 -0400
Message-ID: <006e01c55d76$4adf27f0$797ba8c0@jfradkin> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jfradkin@wazagua.com
Subject: Re: cant seem to post the explain
In-Reply-To: <006e01c55d76$4adf27f0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox