postgresql-topn
postgresql-topn copied to clipboard
citusdata
TopN is an open source PostgreSQL extension that returns the top values in a database according to some criteria
I have encountered with an error when I execute a query stated in TopN Readme page, over a citus distributed table. The same query worked when I used a reference...
in external/topn/topn.c: PruneHashTable function The comment said "It finds minimum and maximum frequencies first and removes the items which have lower frequency than the average of them." The code however...
Hello: when I test this extension with command make installcheck,ERROR named desired number of counters is higher than the topn.number_of_counters variable happened, just like blow: test add_agg ... ok 427...
I seem to repeatedly get the following assert failure when running tests on PG14: ``` TRAP: FailedAssertion("flags & HASH_STRINGS", File: "dynahash.c", Line: 427, PID: 2936) postgres: marco contrib_regression [local] SELECT(ExceptionalCondition+0xa5)[0x55a1fcdaa8a9]...
The data is not stored in the working directory, but fetched by a script. See test_data_provider, and .gitignore entries for the fetched csv files. Fixes: #27
Support for adding (subtracting) a custom value would be nice. `topn_add(jsonb, text, integer)`
Support for negative counters would be nice. ``` select topn_union('{"asd":-1}'::jsonb, '{"asd":2}'::jsonb) select topn_add('{"asd":-1}'::jsonb, 'asd') topn_union_agg(...) ``` They overflow now.
We no longer use lfs to store large datasets in this repo. The `.gitattributes` files need to be revised to remove these dependencies. We may also need to supply a...
We're curious about solving the following use case: 1. Having several TOPN with different maximum counters. 2. Having several TOPN with different maximum key length. Ideally we would have a...
