vote up 4 vote down star
1

Does anyone know what substantial differences there are between the regular PostgreSQL (www.postgresql.org) and Postgres Plus (http://www.enterprisedb.com/products/postgres_plus.do)?

flag

3 Answers

vote up 6 vote down check

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.

link|flag
2  
Given that the main developer of pgAdmin3 works for EDB the similarity is not a coincidence. – Milen A. Radev Dec 5 '08 at 16:02
vote up 3 vote down

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.

link|flag
What sort of queries. Was it a transactional application, a data warehouse, a report off an operational system? – ConcernedOfTunbridgeWells Dec 5 '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 5 '08 at 16:01
vote up 2 vote down

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

link|flag

Your Answer

Get an OpenID
or
never shown

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