On Thu, Aug 24, 2006 at 06:12:32PM -0300, André José Guergolet wrote:
>
> My system, checks if my script is running in each machine at this
> table, this table has 360 rows and has 50-100 updates per minute in
> columns STATE and STATEDATE.
How often are you vacuuming it? Long-running UPDATEs wi
I have the following:name effective tstamp rateJohn 01-01-2006 2005-12-07 13:39:07.614945 115.00John 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 outp
On Fri, Aug 25, 2006 at 04:16:07PM -0400, Henry Ortega wrote:
> I have the following:
>
> name effective tstamp rate
> John 01-01-2006 2005-12-07 13:39:07.614945115.00
> John 01-16-2006 2006-01-07 13:39:07.614945125.00
> Jo
> I have the following:
>
> name effective tstamp rate
> John 01-01-2006 2005-12-07 13:39:07.614945115.00
> John 01-16-2006 2006-01-07 13:39:07.614945125.00
> John 01-16-2006 2006-01-09 15:13:04.4169351885.00
Yes the data does not change once it is logged.I am quite new to this whole thing, do you mind elaborating moreabout the OLAP data model you mentioned about?On 8/25/06,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
I would assume that your data does not change after it is logged. If this is the
> 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?
Well just to give a generalization using an OLAP as your data model, the data
is stored in a
denormalized yet defined model. Data
