PostgreSQL vs Postgres Plus

Question

Does anyone know what substantial differences there are between the regular PostgreSQL and Postgres Plus?

score 14 · Accepted Answer · answered Dec 05 '08 at 15:07

The database is the same, meaning that the SQL is fully compatible to any other PostgreSQL installation around (save for the GIS data formats).

The main difference is that there is a bunch of modules and tools bundled with Postgres Plus that you would have to collect and install separately and by yourself otherwise. Thus the main advantage is easy and speedy installation.

Most of the bundled stuff looks like it's freely available from other sources. That Postgres Studio application looks suspiciously close to pgAdmin III.

Given that the main developer of pgAdmin3 works for EDB the similarity is not a coincidence. — Milen A. Radev, Dec 05 '08 at 16:02

score 14 · Answer 2 · answered Mar 12 '09 at 14:12

14

One important difference is the licence: Postgres Plus is only free for "non-production" use. you can find detailed purchasing options here: http://www.enterprisedb.com/products/purchase.do

answered Mar 12 '09 at 14:12

score 7 · Answer 3 · edited Jul 24 '15 at 18:17

7

Postgres PLUS is proprietary, PostgreSQL is Open source under permissive license (and that's why Postgres PLUS is proprietary).

Postgres PLUS has support for Oracle PL/SQL, while PostgreSQL does not, at least not officially.

Those are two most obvious differences.

edited Jul 24 '15 at 18:17

iconoclast

21,213
15
102
138

answered May 05 '10 at 17:14

user333677

71
1
3

score 3 · Answer 4 · answered Dec 05 '08 at 14:55

3

I used 8.2 and when was the time to switch to 8.3 I tried PostGresPlus.

The Speed was a lot faster. LOT I mean queries that took 30 secs, takes now less than 2 seconds. I am not sure if it's 8.3 that is faster or the Enterprise Plus but I can tell you that I was impressed.

Other thing that I like is that I can debug proc stored. It cames with more tools.

answered Dec 05 '08 at 14:55

Patrick Desjardins

136,852
88
292
341

1

What sort of queries. Was it a transactional application, a data warehouse, a report off an operational system? – ConcernedOfTunbridgeWells Dec 05 '08 at 15:22
I've never used the Plus distibution but the difference in performance probably comes from the different default configuration - the default configuration for the "community" version has always been somewhat conservative (less recently). – Milen A. Radev Dec 05 '08 at 16:01
PostgreSQL has minimalistic default configuration - with low shared_buffers and low work_mem. PostgreSQL Plus has these higher these values. Next - there was a significant speedup between 8.2 and 8.3 - PostgresPlus uses same engine as PostgreSQL so there should not be different performance with same configuration. – Pavel Stehule Jan 03 '12 at 07:10
3

PostgreSQL 8.3 can easily be 10X as fast as PostgreSQL 8.2 on common workloads. Perhaps some of the speedup you saw came from something specific to Postgres Plus, but you would have to compare community PostgreSQL 8.3 vs. Postgres Plus 8.3 to be sure. The only thing you learned so far for sure is that all 8.3 variations of PostgreSQL are faster than all 8.2 variations. – Greg Smith Sep 16 '14 at 18:25

PostgreSQL vs Postgres Plus

4 Answers4

Linked