![]() Now, if you are willing to have more challenge to find PostgreSQL specialists or you are willing to train your team for PostgreSQL, go for it! Today (2016) PostgreSQL is the most advanced open-source RDBM and is on-par for most deployments with commercial competition.Īre there required features that only one database system offers? You cannot use advanced features of both database platforms, so check what it is that your application really needs. It is not just Oracle, but it is very likely that it's easier to find Oracle or MSSQL specialist in every country. Who is going to support your website (and database)? There are enterprise db companies out there which can provide world wide support, documentation, consultants etc. drop a column)Īs much as I like PostgreSQL one thing that can be really annoying is configuring (auto)vacuum to cope with high write traffic. Changing tables that are used in views (e.g.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 ASH and AWR reports (Postgres 9.6 added the infrastructure to have something like that in the future).Index organized tables (aka "clustered indexes").transaction control in stored procedures (there will be support for that in the upcoming Postgres 11, but not as complete as in Oracle).Index only scans (available since Postgres 9.2, but not as efficient as Oracle's implementation in my experience).Flashback queries and flashback archives (they are really cool).Materialized views (available since Postgres 9.3, but Postgres still has no incremental refresh or query rewrite).Things where Oracle offers still more features: ![]() 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). And all such programs still have more restrictions on what you can do with them than the Multi-Master Oracle installations provide.My opinion is that PostgreSQL is very close to Oracle, especially with the upcoming 9.1 which offers an alternative to Oracle's DataGuard. It's possible to do multi-master in PostgreSQL, but only with add-on software like Bucardo. The main thing you can do in Oracle that is very hard to duplicate as well in PostgreSQL is multi-master replication. I regularly hear that most of those things are so complicated to setup that few Oracle installations get them right either-just because RAC is built-in doesn't mean it sets itself up automatically. You have to assemble the necessary clusterware software around that for PostgreSQL, and there are a variety of advanced things RAC does you'll be hard pressed to duplicate in PostgreSQL. The main difference is that RAC is fully integrated into Oracle's product, while "Shared Disk Failover" just describes a method of doing something. Oracle's RAC is similar to what PostgreSQL is labelling "Shared Disk Failover" in that grid. You can have a fully synchronous "Important!" Transaction followed by an asynchronous "OK to lose" one in Postgres. One advantage that PostgreSQL has over Oracle here is that Sync Rep can be controlled on a per-transaction basis. ![]() ![]() Version 9.1 adds synchronous replication too. Oracle's Data Guard replication is similar to PostgreSQL's "Hot/Warm Standby Using PITR", which is built-in to the database as of PostgreSQL 9.0. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |