News for hackers. Stuff that matters.
Re:Hstore development for 9.4 release by Herald_MJ on Thursday November 07, 2013 @10:55AM (#6690036)
In my experience, mongo doesn't even scale horizontally all that well...
Re:Hstore development for 9.4 release by misiti3780 on Thursday November 07, 2013 @11:02AM (#6690085)
any more details? - im about to scale a large mongo database horizontally and wondering what I should be watching out for
Re:Hstore development for 9.4 release by tete on Thursday November 07, 2013 @11:22AM (#6690230)
If you want to scale out using a replica-strategy you really want to have the most recent version of PostgreSQL. It made things like log shipping pretty much an automatic experience. It still has rough edges, but the latest version really makes a difference here. See the release notes of PostgreSQL.

You will however find plenty of information on the wiki. Sometimes it is not completely up to date because of so much going on on that front.

You can use third party solutions too, but they usually have a number of caveats and general problems. However it depends on what you do with your database. If you don't deal with writing your own functions, use extensions or have fancy transaction they will work just fine. If you do, the functionality of Postgres is a more safe strategy. If you are dealing with extensions, etc. you should really be ready to get dedicated support for these things.

However, it really depends on what you do. For everything standard it won't make too much trouble once the first setup is done.