2
votes
1answer
335 views

PostgreSQL and Mongodb in production

We have a product that uses Postgres for RDBMSish data (accounts, billing, etc.) and MongoDB for each of the accounts data (which obviously can't be maintained on Postgres). In local development we ...
2
votes
5answers
3k views

Fast Database to store 1 Billion records [closed]

I am writing a code to store data and want to store 1 Billion to 10 Billion records or even more. Most importantto this is speed (nearly 10000 - 20000 / records per second), SPACE usage and CRASH ...
3
votes
0answers
158 views

Ignoring maturity, which database would be better for storing spatial data? [closed]

I am looking to store possibly millions of spatial locations. I will need to do queries like "hotels within 10 miles of [lat,lng]". I've had a little experience with MongoDB in this regard and was ...
1
vote
2answers
1k views

PostgresQL on Amazon EBS volume, realistic performance, or move to something more lightweight?

I'm working on a little research project, currently running as an instance on ec2, and I'm hoping to figure out whether I'm going down the right path. We, like a thousand other people, are making use ...
1
vote
2answers
883 views

Storing Hundreds of Millions of Records

My company will be coming into possession of a dataset consisting of approximately 200-300 million records. The source material is csv and is about 150GB uncompressed. We would need to perform an ...