Re: Calculating 95th percentiles - Mailing list pgsql-performance

From Pierre C
Subject Re: Calculating 95th percentiles
Date
Msg-id op.vru1k1fgeorkce@apollo13
Whole thread Raw
In response to Calculating 95th percentiles  (Landreville <landreville@deadtreepages.com>)
List pgsql-performance
> Any time the volume tables are queried it is to calculate the deltas
> between each in_octets and out_octets from the previous row (ordered
> by timestamp). The delta is used because the external system, where
> the data is retrieved from, will roll over the value sometimes.  I
> have a function to do this calcuation:

Would it be possible to do this when inserting and store the deltas
directly ?

pgsql-performance by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: Linux I/O schedulers - CFQ & random seeks
Next
From: Tobias Brox
Date:
Subject: Table partitioning