Top all-time · #6013
Alexander Korotkov
Personal blog · akorotkov.github.io/blogdataprogramming
Alexander Korotkov's personal blog at akorotkov.github.io covers data and programming. Since 2016, 13 different Hacker News readers have linked it 18 times, most often “PostgreSQL Scalability: Towards Millions TPS”. The last post was in 2021, but the archive is still widely read.
Too few sampled comments (10) to say how often HN recommends it.?
Why HN links it
HN readers link Alexander Korotkov's blog for its PostgreSQL posts on full-text search, faceted search, and scalability benchmarks, including a claim of around 1M TPS on one server.
Summarised by Claude from a sample of 10 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- PostgreSQL Scalability: Towards Millions TPS6 people · 6 mentions · first linked 2016-05-09
- Faceted Search in a Single PostgreSQL Query3 people · 3 mentions · first linked 2016-06-18
- Extensible Access Methods Are Committed to Postgres 9.62 people · 2 mentions · first linked 2016-04-11
What Hacker News says?
I remember reading your article on FTS in postgres, great stuff. Was wondering what strategies you might be using to perform counts on your data? I'm trying to implement a faceted search in postgres and currently using window functions to count subcategories (a la http://akorotkov.github.io/blog/2016/06/17/faceted-search/ ), but not sure if it's the most efficient.
Comment linking /blog/2016/06/17/faceted-search/
on “Building a Search Engine from Scratch”Submitted PostgreSQL Scalability: Towards Millions TPS as a story · 521 points
HN discussion> Postgres incredibly far Up to the millions of TPS actually. https://akorotkov.github.io/blog/2016/05/09/scalability-towa...
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “Fast key-value stores: An idea whose time has come and gone”Submitted Extensible Access Methods Are Committed to Postgres 9.6 as a story · 23 points
HN discussionOne modern PC server with PostgreSQL can handle about 1 mln transactions per second. http://akorotkov.github.io/blog/2016/05/09/scalability-towar...
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “Maybe You Don't Need Kubernetes (2019)”Submitted PostgreSQL: Our answer to Uber as a story · 5 points
HN discussionEfficient data structures and algos, carefully tuned for one particular scenario. Seems like a good candidate for the one of PostgreSQL pluggable storage engines we will likely see in the future[1]. I hope the data structures are not patented. [1] http://akorotkov.github.io/blog/2016/04/06/extensible-access...
Comment linking /blog/2016/04/06/extensible-access-methods/
on “TrailDB – An Efficient Library for Storing and Processing Event Data”Submitted Faceted Search in a Single PostgreSQL Query as a story · 3 points
HN discussionDoing json serialisation in the db is the only way to extract tree like data from the db. Another point to consider is that this is a much lower burden on the database then you think (roughly speaking, it adds 15%-20% more cpu load then a normal query), this is C code doing this, can't get much faster that. This type of load is easily horizontally scalable using read replicas which in RDS is basically one click. But…
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “PostgREST – A fully RESTful API from any existing PostgreSQL database”Submitted Drawing Graphs Directly in Psql as a story · 2 points
HN discussionHave you seen Alexander Korotkov post "Faceted Search in the Single PostgreSQL Query" http://akorotkov.github.io/blog/2016/06/17/faceted-search/
Comment linking /blog/2016/06/17/faceted-search/
on “Implementing faceted search with Django and PostgreSQL”Submitted PostgreSQL 14: Substantion Change to Fulltext Query Parsing as a story · 1 points
HN discussionThat doesn't sound right. Even the newest NVMe devices can't do 1M writes per second; they're maxing out at around 330k IOPS. The 1M "TPS" you're referring to is a read-only benchmark (e.g. http://akorotkov.github.io/blog/2016/05/09/scalability-towar... ). Those are reads (most likely from the buffer cache), not writes or transactions in any real sense.
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “120K distributed consistent writes per second with Calvin”Submitted Rainbow your psql output in honor of IDAHOT day as a story · 1 points
HN discussionThat's nice, and you can get a 1,000,000 tps on the shelf POWER8 server if you wish (on simple select-only requests, after tuning and patching the PostgreSQL core by a couple of the best PostgreSQL hackers in the world - yes, using carefully crafted assembler, no less https://akorotkov.github.io/blog/2016/05/09/scalability-towa... ). That wouldn't make that server competitor neither for IBM Parallel Sysplex, nor eve…
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “Delta Computer Glitches Force Flight Halts Third Year in a Row”Submitted Jsonpath: ** Operator and Lax Mode Are't Meant to Be Together as a story · 1 points
HN discussionI also love the "Reasons to use SQL": > If your business is not experiencing massive growth that would require more servers and you’re only working with data that’s consistent, then there may be no reason to use a system designed to support a variety of data types and high traffic volume. This whole article seems heavily NoSQL biased. I don't know what qualifies as high traffic volume, but Postgres has been known to…
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “SQL vs. NoSQL Databases: What’s the Difference?”I visited your site and, to be honest, to me it is unclear why I would should choose your solution over for example PostgreSQL. * "Fast": up to 130.000 TPS (inserts apparently) sounds a lot, but I'm not sure it is, see for example http://akorotkov.github.io/blog/2016/05/09/scalability-towar... . Maybe I'm comparing apples with oranges, but since your statement is not backed up by anything I can verify myself this do…
Comment linking /blog/2016/05/09/scalability-towards-millions-tps/
on “Ask HN: Selling Software, How?”
