Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been asked for recommendation on the optimal RDBMS for a large amount of data. The largest table would contain 2TB of data. My own largest table is only 400GB (mysql, performs very well).

The individual rows are going to be short, no blobs/etc, just a lookup table.

Is PostgreSQL nowadays performing better than MySQL? Can I ask DBAs with tables in this order of magnitude for their experience? Oracle might be considered as well. The available hardware is probably a standard linux box with about 64G ram.

share|improve this question

closed as primarily opinion-based by Michael - sqlbot, Mat, StanleyJohns, Marian, Mark Storey-Smith Jul 25 '13 at 7:13

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

up vote 0 down vote accepted

I would go with MySQL (InnoDB engine of course) if your table is partitioned. PostgreSQL partitioning implementation with master-child tables and trigger based partition selection looks somewhat complicated for me. On the other hand in Oracle to use partitions one have to use Enterprise Edition ($47500 for 2 cores!) with Partitioning option (another $11500 for 2 cores).
From experience we have similar sized tables in both Oracle and MySQL. Performance and management is OK with both of them.

share|improve this answer

The size of the tables really doesn't matter all that much. It's all about how well indexed the tables are and how many people are using the database at once.

In my case I've got clients with billions of rows in a single table where the table size is about 1 TB and another 2 billion row table which has blobs. These tables crank without performance issues at all.

In this case the server has 1TB of RAM, 80 cores, and is running Microsoft SQL Server 2008 R2. Granted not all that helpful if you want a *nix OS, but it gives you some ideas that most database platforms can handle just about everything.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.