列出函數 \df topn* List of functions Schema | Name | Result data type | Argument data types | Type --------+---------------------+-------------------+---------------------+------ public | topn | SETOF topn_record | jsonb, integer | func public | topn_add | jsonb | jsonb, text | func public | topn_add_agg | jsonb | text | agg public | topn_add_trans | internal | internal, text | func public | topn_deserialize | internal | bytea, internal | func
3/19/2021參考資料 Github https://github.com/citusdata/postgresql-topn 簡報及介紹 https://speakerdeck.com/citusdata/the-topn-extension-maintaining-top-10-lists-at-scale-pgconf-eu-2019-furkan-sahin https://www.citusdata.com/blog/2018/03/27/topn-for-your-postgres-database/ 安裝
3/19/2021or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up