Re: Calculating 95th percentiles

From: "Pierre C" <lists(at)peufeu(dot)com>
To: pgsql-performance(at)postgresql(dot)org, Landreville <landreville(at)deadtreepages(dot)com>
Subject: Re: Calculating 95th percentiles
Date: 2011-03-05 07:54:27
Message-ID: op.vru1k1fgeorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tobias Brox 2011-03-05 09:37:20 Table partitioning
Previous Message Rosser Schwarz 2011-03-04 19:09:34 Re: Linux I/O schedulers - CFQ & random seeks