Re:Urban Airship: Postgres to NoSQL and back
by sheff on Monday September 19, 2011 @05:56PM
(#3015372)
I believe this was one of the talks at Postgres Open - I came across the slides from most of the others earlier at
http://wiki.postgresql.org/wiki/Postgres_Open_Talks_2011, and they have some good tips on scaling with Postgres.
There was one interesting tidbit in one of the Heroku presentations : they apparently run over 150,000 databases ( https://wal-e-pgopen2011.herokuapp.com/#6 ) which is incredible.
Re:Urban Airship: Postgres to NoSQL and back
by robotadam on Monday September 19, 2011 @06:32PM
(#3015483)
The Heroku guys are doing some seriously awesome things with Postgres. I can't wait to see where they go with it; the whole community will benefit, I'm sure.
Re:Urban Airship: Postgres to NoSQL and back
by joelhaasnoot on Monday September 19, 2011 @05:52PM
(#3015360)
One thing that I ran into in addition to the above was that while the database and driver for my language of choice (Node.js) were fine, I ran into all sorts of ORM issues that weren't being fixed and were very odd. Mixing a not so stable community project around Mongo with far from stable project (Node) was a bad idea...
I agree with the guy. PostgreSQL (and SQL server ironically) have kept me up less than any other piece of software out there.
I'm watching a turd occuring with MongoDB at the minute. Every time something breaks, I hear the team saying "it'll be fixed in the next version" or "feature X works around it for now". Grr. Too much marketing, not enough reliability study.