Why Use Postgres

Re:Why Use Postgres by gouranga on Monday April 30, 2012 @06:26PM (#3911889)

It goes much faster I agree. However you are very short sighted. That black box doesn't go on forever. It will work fine for the first 50 users, seems ok for the next 100, 500 we're doing ok. 1000 BOOM! Then what do you do?

I'd rather have a slightly higher latency and be able to scale to 100,000 users.

Materialized views are not needed with CQRS architecture. ALL tables (or sets) are materialized views already. No joins are ever made.

dblink is ugly and if you ask me a problem, not a solution (latency, network io, memory).

I'm not sure what you classify as "larger" but I'm talking tens of Tb, 1500 tables and over 2 million LOC in the application.

[ Parent | on HN ]

Re:Why Use Postgres by joevandyk on Monday April 30, 2012 @06:44PM (#3911963)

Instagram did just fine with postgresql with 27 million users. Many logical shards spread over a smaller amount of physical ones.

http://www.databasesoup.com/2012/04/sharding-postgres-with-i...

[ Parent | on HN ]

Re:Why Use Postgres by gouranga on Monday April 30, 2012 @06:55PM (#3912010)

Instagram isn't very complicated to be honest so I doubt that's a good scalability example.

[ Parent | on HN ]

Re:Why Use Postgres by joevandyk on Monday April 30, 2012 @07:06PM (#3912049)

Skype's plan to support 1 billion users w/ postgres a few years ago? http://highscalability.com/skype-plans-postgresql-scale-1-bi... and http://www.slideshare.net/adorepump/small-overview-of-skype-...

Billions of records, 10,000 transactions per second. This was a couple of years ago.

Dunno if Skype is complicated enough for you.

[ Parent | on HN ]

Re:Why Use Postgres by erichocean on Monday April 30, 2012 @07:22PM (#3912093)

I get the sense he'll ratchet up what "complicated" means until he wins the argument. :)

[ Parent | on HN ]

Re:Why Use Postgres by gouranga on Tuesday May 01, 2012 @03:40AM (#3913393)

No just there is a difference between large and complicated.

[ Parent | on HN ]

Re:Why Use Postgres by bingbing on Tuesday May 01, 2012 @12:55AM (#3913062)

EVE Online runs on a single SQL Server 2008 instance:

http://wiki.eveonline.com/en/wiki/Tranquility#Database_Serve...

serving hundreds of thousands of users

[ Parent | on HN ]

Re:Why Use Postgres by gouranga on Tuesday May 01, 2012 @04:41AM (#3913492)

> At peak hours as of 2007 the database handles around 2-2.5k transactions per second, which generate roughly 40,000 input/output operations per second on the disks.

That's not much...

[ Parent | on HN ]

Re:Why Use Postgres by jacques_chester on Wednesday May 02, 2012 @01:11AM (#3917720)

They're complex transactions. Inserts against dozens of tables, selects from dozens of tables. We're not talking about glorified KV lookups here.

[ Parent | on HN ]