FUfurkansahin·May 21, 2018Submission
Postgresql-topn: TopN extension for PostgreSQL
1 points · Open discussioncitusdata
postgresql-topn
C2018–2018
citusdata / postgresql-topn
postgresql-topn
TopN is an open source PostgreSQL extension that returns the top values in a database according to some criteria
3Distinct people
4Mentions
0Explicit recommenders
249GitHub stars
What to know before exploring
What it is
TopN is an open source PostgreSQL extension that returns the top values in a database according to some criteria
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 8–Nov 15 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/15/2026, 2:04:58 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by week4 dated mentions
Observed mentions: 2018-03-27 18:05:26 UTC to 2018-05-21 19:19:35 UTC. Weeks start Monday, UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Mar 26 | 2018-03-26 00:00:00 UTC | 2018-04-02 00:00:00 UTC | 1 | 1 | 0 |
| Apr 2 | 2018-04-02 00:00:00 UTC | 2018-04-09 00:00:00 UTC | 0 | 0 | 0 |
| Apr 9 | 2018-04-09 00:00:00 UTC | 2018-04-16 00:00:00 UTC | 1 | 0 | 1 |
| Apr 16 | 2018-04-16 00:00:00 UTC | 2018-04-23 00:00:00 UTC | 0 | 0 | 0 |
| Apr 23 | 2018-04-23 00:00:00 UTC | 2018-04-30 00:00:00 UTC | 0 | 0 | 0 |
| Apr 30 | 2018-04-30 00:00:00 UTC | 2018-05-07 00:00:00 UTC | 1 | 1 | 0 |
| May 7 | 2018-05-07 00:00:00 UTC | 2018-05-14 00:00:00 UTC | 0 | 0 | 0 |
| May 14 | 2018-05-14 00:00:00 UTC | 2018-05-21 00:00:00 UTC | 0 | 0 | 0 |
| May 21 | 2018-05-21 00:00:00 UTC | 2018-05-28 00:00:00 UTC | 1 | 1 | 0 |
What Hacker News says
4 sourcesPostgresql-topn: TopN extension for PostgreSQL
1 points · Open discussion(Ozgun from Citus Data)
What really excites me about this blog post is how PostgreSQL is becoming central across diverse workloads - including real-time analytics.
A few Postgres resources that relate to this blog post are the following.
1. TopN: Several Citus customers were already using the TopN extension. Algolia contributed to revising the public APIs in this extension. With these revised APIs, we felt pretty comfortable in open sourcing the extension for the Postgres community to use: https://github.com/citusdata/postgresql-topn
2. Postgres JIT improvements: Postgres 11 is coming with LLVM JIT improvements. For analytical queries that run in-memory, these changes will improve query performance by up to 3x. This will significantly speed up roll-up performance mentioned in this blog post: https://news.ycombinator.com/item?id=16782052
3
Read the rest
. For those interested, this tutorial talks about how to build real-time analytics ingest pipelines with Postgres: https://www.youtube.com/watch?v=daeUsVox8hs
postgresql-topn: TopN PostgreSQL extension
5 points · Open discussion