看到有人發問 https://www.facebook.com/groups/taiwanmysqlusergroup/permalink/1852399401574463/ 建立測試資料 create table t0416 ( id int not null auto_increment primary key , col varchar(12) not null ); insert into t0416 (col) values

列出函數 \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

參考資料 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/ 安裝