PostgreSQL 与 Postgres Plus
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/344038/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PostgreSQL vs Postgres Plus
提问by Berufsstudent
Does anyone know what substantial differences there are between the regular PostgreSQLand Postgres Plus?
有谁知道常规 PostgreSQL和Postgres Plus之间有什么实质性区别？
回答by Berufsstudent
The database is the same, meaning that the SQL is fully compatible to any other PostgreSQL installation around (save for the GIS data formats).
数据库是相同的，这意味着 SQL 与任何其他 PostgreSQL 安装完全兼容（除了 GIS 数据格式）。
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.
主要区别在于 Postgres Plus 捆绑了一堆模块和工具，您必须单独收集和安装，否则您必须自己收集和安装。因此，主要优点是安装简单快捷。
Most of the bundled stuff looks like it's freely available from other sources. That Postgres Studio application looks suspiciously close to pgAdmin III.
大多数捆绑的东西看起来都可以从其他来源免费获得。Postgres Studio 应用程序看起来与 pgAdmin III 非常接近。
回答by Berufsstudent
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
一个重要的区别是许可证：Postgres Plus 仅可免费用于“非生产”用途。您可以在此处找到详细的购买选项：http: //www.enterprisedb.com/products/purchase.do
回答by user333677
Postgres PLUS is proprietary, PostgreSQL is Open source under permissive license (and that's why Postgres PLUS is proprietary).
Postgres PLUS 是专有的，PostgreSQL 在许可许可下是开源的（这就是 Postgres PLUS 是专有的原因）。
Postgres PLUS has support for Oracle PL/SQL, while PostgreSQL does not, at least not officially.
Postgres PLUS 支持 Oracle PL/SQL，而 PostgreSQL 不支持，至少官方没有支持。
Those are two most obvious differences.
这是两个最明显的区别。
回答by Patrick Desjardins
I used 8.2 and when was the time to switch to 8.3 I tried PostGresPlus.
我使用了 8.2，什么时候切换到 8.3 我尝试了 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.
速度快了很多。很多我的意思是需要 30 秒的查询，现在不到 2 秒。我不确定是 8.3 还是 Enterprise Plus 更快，但我可以告诉你，我印象深刻。
Other thing that I like is that I can debugproc stored. It cames with more tools.
我喜欢的另一件事是我可以调试存储的 proc。它带有更多工具。
