Re: Best way to do this query.. - Mailing list pgsql-sql

From Henry Ortega
Subject Re: Best way to do this query..
Date
Msg-id 2bffcc330608251343r67a73ab6x51fde94cc74dbdd4@mail.gmail.com
Whole thread Raw
In response to Re: Best way to do this query..  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Best way to do this query..  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Best way to do this query..
Next
From: Richard Broersma Jr
Date:
Subject: Re: Best way to do this query..