Hacker News new | ask | show | jobs
by rastignack 672 days ago
> This is exactly a great point. When data size goes to a billion rows, Postgres is tough. MongoDB just works without issue.

Is it though ? Maybe 5-10 years ago it was.
1 comments
endisneigh 672 days ago
It is still true that vanilla Postgres doesn’t scale well beyond multiple machines. There are extensions that help, though.
link
rastignack 672 days ago
My point is that you can handle a billion of rows on a single PostgreSQL instance.
link
endisneigh 672 days ago
Looking at the sheer number of rows isn’t really helpful - you’d need to know the query profile. Any database can simply store a billion rows.
link