| Package | postgresql-18-aggs-for-arrays |
| Source | aggs-for-arrays |
| Version | 1.3.3-1PIGSTY~trixie |
| Architecture | amd64 |
| Maintainer | Ruohang Feng |
| Installed-Size | 121 |
| Depends | postgresql-18, libc6 (>= 2.14) |
| Provides | postgresql-aggs-for-arrays |
| Homepage | https://github.com/pjungwir/aggs_for_arrays |
| Priority | optional |
| Section | database |
| Filename | pool/main/a/aggs-for-arrays/postgresql-18-aggs-for-arrays_1.3.3-1PIGSTY~trixie_amd64.deb |
| Size | 43896 |
| SHA256 | a09afd68435129bc8cda7497d32ffd5154daddb9ce93ee37061d6ac28a4cedd2 |
| SHA1 | 75f054144085f0865a624ef891549a16d226a6c8 |
| MD5sum | e3b890162d5f9ed204e1141392833d7a |
| Description | A Postgres extension in C to compute statistics on arrays of numbers
This Postgres extension provides various functions for operating on arrays, for instance taking the histogram of an array of numbers.
These functions are useful because if you have a lot values you want to aggregate, queries that fetch each value from a separate row
can have poor performance. Storing all the values in a single row as a Postgres array can drastically improve query performance.
For instance, computing a 1000-bucket histogram on one million float values stored in separate rows took 12 seconds in a simple benchmark,
compared to 27 milliseconds with the array_to_hist function. |
| Description-md5 | |