Postgresql vs Oracle [closed]

Question

Well, the subject suggests the question:

1. Oracle has a good support, so has enterpriseDB
2. Huge amount of data can be easily managed by Oracle, Specs of PostgreSql suggest the same
3. Feature wise I'm not sure, but reading on internet about both the DBs result in a tie

I wonder now, why oracle is more popular.

Which DB should be considered (leave the license/money thing) for a website which should be scaleable and may have large number of active users (lets say 10,000 users online).

I'm not looking for anything like Cassandra, mongo DB etc...

Answer 1

My opinion is that PostgreSQL is very close to Oracle, especially with the upcoming 9.1 which offers an alternative to Oracle's DataGuard.

On the SQL Level there are really head-to-head, not much difference (with Postgres having actually more "little helpers" and features that make life a lot easier).

Things where Oracle offers still more features:

• Materialized views (available since Postgres 9.3, but Postgres still has no incremental refresh or query rewrite)
• Flashback queries and flashback archives (they are really cool)
• Index only scans (available since Postgres 9.2, but not as efficient as Oracle's implementation in my experience)
• transaction control in stored procedures (there will be support for that in the upcoming Postgres 11, but not as complete as in Oracle)
• Index organized tables (aka "clustered indexes")
• ASH and AWR reports (Postgres 9.6 added the infrastructure to have something like that in the future)
• parallel queries
  Postgres 9.6 added some basic ability to run queries in parallel, Postgres 10 improved that even more and Postgres 11 will even be able to use it for things like create table as
• parallel DML
• Changing tables that are used in views (e.g. drop a column)

As much as I like PostgreSQL one thing that can be really annoying is configuring (auto)vacuum to cope with high write traffic.