PostgreSQL has much lower system resource requirements than Oracle. I currently look after 200+ PostgreSQL databases running on various sized servers, including tiny virtual machines. Some servers have as many as 40 databases on them. With Oracle, I don’t think I ever had more than around 10 on a single server.
Oracle’s hardware requirements (11gR2):
- 1 GB disk space in temp directory
- 4.5 GB disk space for binaries (Enterprise Edition)
- 4 GB RAM (for 64-bit install)
- About 512 MB minimum per database
PostgreSQL’s hardware requirements (9.0):
- 25MB disk space for binaries
- I couldn’t even find information on the minimum RAM requirements (go documentation!) but it will pretty much run on anything.
If you are considering a change of platform from PostgreSQL to Oracle, this is a major consideration. With it being so easy to create new PostgreSQL databases, they tend to breed themselves over time. The hardware you have now probably won’t cut it if moving to Oracle.
Read more: Oracle DBA in a PostgreSQL world
Posts
0 comments:
Post a Comment