I gang

Postgresql performance optimization

We have a table containing the speed of vehicles with location id and timestamp (postgres database). We need to improve the calculation time of statistic function that calculates the speed

We need to get the value of the fastest of the 85% slowest entries

(number of entries to be rounded up, i.e. 85% of 10 = 9)

Example :

SELECT speed FROM table ;

speed

-------

88

11

5

22

20

50

10

70

80

71

(10 rows)

SELECT agg_v85(speed) FROM table;

agg_v85(speed)

----------------

80

(1 row)

Explanation :

- If the above array is sorted ORDER BY speed ASC, one can see entries #8 as 71, #9 as 80 and #10 as 88

- 85% of 10 = 9 (CEIL)

- Entry #9 = 80 and result = 80

Færdigheder: C programmering, Datasøgning, Matematik, SQL, Statistikker

Se mere: postgresql optimization, programming array, array programming, timestamp, swissembedded, sql database improve, speed programming, speed optimization, postgresql c++, postgres, database performance , database optimization, table optimization, sql select order, optimization database, improve performance, function postgres, postgresql sql, statistic table, sql postgres, postgresql table, location sql database, Performance Optimization, performance order, entry programming

Om arbejdsgiveren:
( 36 bedømmelser ) Rieden, Switzerland

Projekt-ID: #930357

Tildelt til:

matejp

Hello sir, please read PM

$30 USD på 1 dag
(1 bedømmelse)
1.0
smartachive

I can do this. I bid this for 3 days because, I need to conform the result with some test cases with you before release.

$30 USD in 3 dage
(1 bedømmelse)
1.0

4 freelancere byder i gennemsnit $35 for dette job

Ohuma

Hi, see PMB for details.

$50 USD på 1 dag
(16 bedømmelser)
5.7
srikantasr

Hi Please check your PM.

$30 USD in 0 dage
(0 bedømmelser)
0.0