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)?
+3
A:
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.
Daok
2008-12-05 14:55:06
What sort of queries. Was it a transactional application, a data warehouse, a report off an operational system?
ConcernedOfTunbridgeWells
2008-12-05 15:22:51
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
2008-12-05 16:01:12
+6
A:
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.
Berufsstudent
2008-12-05 15:07:16
Given that the main developer of pgAdmin3 works for EDB the similarity is not a coincidence.
Milen A. Radev
2008-12-05 16:02:33
+4
A:
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
A:
For all of those who think that Daok's speed-up is because PostgresPlus is faster, it's not. It's 8.3 from what I've heard.
JustMe
2010-06-26 14:19:12