From: Henry Ortega <juandelacruz@gmail.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Best way to do this query..
Date: Fri, 25 Aug 2006 16:43:44 -0400
Message-ID: <2bffcc330608251343r67a73ab6x51fde94cc74dbdd4@mail.gmail.com> (raw)
In-Reply-To: <20060825204057.31139.qmail@web31810.mail.mud.yahoo.com>
References: <2bffcc330608251316g6ed00710u6e43b243800c6087@mail.gmail.com>
<20060825204057.31139.qmail@web31810.mail.mud.yahoo.com>
Yes the data does not change once it is logged.
I am quite new to this whole thing, do you mind elaborating more
about the OLAP data model you mentioned about?
On 8/25/06, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
> I would assume that your data does not change after it is logged. If this
> is the case, maybe this
> part of your data model would actually be a good canidate for an OLAP data
> model.
>
> If this is not the direction your are enterested in moving, you could
> also reduce your query
> processing time by limiting the data ranges for your existing query to
> something for reasonable.
>
> Regards,
>
> Richard Broersma Jr.
>
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-sql@postgresql.org
Cc: juandelacruz@gmail.com, rabroersma@yahoo.com
Subject: Re: Best way to do this query..
In-Reply-To: <2bffcc330608251343r67a73ab6x51fde94cc74dbdd4@mail.gmail.com>
* 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