logoalt Hacker News

terafloptoday at 12:55 AM5 repliesview on HN

I don't mean this as a knock on you, but your comment is a bit funny to me because it has very little to do with "modern" databases.

What you're describing would probably have been equally possible with Postgres from 20 years ago, running on an average desktop PC from 20 years ago. (Or maybe even with SQLite from 20 years ago, for that matter.)

Don't get me wrong, Postgres has gotten a lot better since 2006. But most of the improvements have been in terms of more advanced query functionality, or optimizations for those advanced queries, or administration/operational features (e.g. replication, backups, security).


Replies

kccqzytoday at 1:05 AM

The article actually points out a number of things only added after 2006, such as full-text search, JSONB, etc. Twenty years ago your full-text search option is just LIKE '%keyword%'. And it would be both slower than less effective than real full-text search. It clearly wasn’t “sub-100ms queries for virtually anything you want” like GP said.

stousettoday at 2:25 AM

And 20 years ago people were making the exact same kinds of comments and everyone had the same reaction: yeah, MySQL has been putting numbers up like that for a decade.

dimgltoday at 2:18 AM

20 years ago was 2006? Oh no...

show 1 reply
TacticalCodertoday at 2:18 AM

> Don't get me wrong, Postgres has gotten a lot better since 2006.

And hardware has gotten a lot better too. As TFA writes: it's 2026.

BeetleBtoday at 1:01 AM

[flagged]