Sharath Gururaj agsha
agsha
/ postgres bulk percentiles calculation
Created
March 30, 2020 13:16
— forked from evan-burke/postgres bulk percentiles calculation
Postgres bulk percentile calculation with generate_series() and percentile_cont()
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| This will return the percentiles in order. | |
| -- #1 | |
| select unnest( | |
| percentile_cont( | |
| (select array_agg(s) from generate_series(0, 1, 0.2) as s) | |
| ) WITHIN GROUP (ORDER BY SIZE)) | |
| from mytable |