From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Henry Ortega <juandelacruz@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Best way to do this query..
Date: Fri, 25 Aug 2006 13:40:56 -0700 (PDT)
Message-ID: <20060825204057.31139.qmail@web31810.mail.mud.yahoo.com> (raw)
In-Reply-To: <2bffcc330608251316g6ed00710u6e43b243800c6087@mail.gmail.com>
> I have the following:
>
> name effective tstamp rate
> John 01-01-2006 2005-12-07 13:39:07.614945 115.00
> John 01-16-2006 2006-01-07 13:39:07.614945 125.00
> John 01-16-2006 2006-01-09 15:13:04.416935 1885.00
>
> I want the output to be:
> name effective end_date rate
> John 01-01-2006 01-15-2006 115.00
> John 01-16-2006 1885.00
>
> What is the best way to do this? This is on a huge table and what I
> have right now is quite slow. Any ideas?
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: rabroersma@yahoo.com, juandelacruz@gmail.com
Subject: Re: Best way to do this query..
In-Reply-To: <20060825204057.31139.qmail@web31810.mail.mud.yahoo.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