Postgres Plus® Standard Server Version 8.4 Now Available!

Standard Server 8.4 delivers PostgreSQL 8.4, StackBuilder Plus with UpdateMonitor, pre-integrated enterprise modules, value-added enterprise module testing, and enterprise subscription, support, and packaged services.

What's New? In Community PostgreSQL? EnterpriseDB / Standard Server
Value Add
All PostgreSQL 8.4 features
Yes
Code and feature contributions
Pre-integrated and pre-installed enterprise add-on modules (e.g. connectors, geospatial, replication, caching, etc. )
No
 
Add-on project collection, compilation, packaging, testing, and installing.
StackBuilder Plus with UpdateMonitor
 
No
 
Automatic notification of updates to installed add-on modules
Value-added integration testing of add-on modules
 
No
 
Integration testing of 8+ enterprise add-on modules.
Software Subscriptions, Technical Support, Service Level Agreements, Training, Services
No
 
Highest concentration of Postgres expertise in the world.


Postgres Plus Standard Server Frequently Asked Questions


What is the difference between Standard Server and Advanced Server?


First, Advanced Server contains all the features included in Standard Server. Advanced Server is then optimized for large scale enterprise wide applications. It contains additional powerful features for database application development that also enable applications written for Oracle databases to run on top of Postgres database engines. Many of the features enhance performance such as: DynaTune®, EDB*Loader, and Distributed Federated Queries.

 

For more sophisticated programming, Advanced Server includes built in packages, programmable Bulk Collect and Bulk Bind functions, Query Optimization Hints, DRITA, explicit transaction control, and audit logging. Finally, Advanced Server provides a more sophisticated tool set including Postgres Studio with an enhanced debugger for in context application debugging, the DBA Management Server, the DBA Monitoring console, the Migration Studio, and an Oracle® Replication console.

 

Do Postgres Plus servers support Partitioning?


Yes, it is a fundamental feature of the database and supports Range, List and Hash partitioning (GridSQL®).

 

Does Toad® from Quest® work with Postgres Plus servers?


Quest has a version of Toad called Toad for Data Analysts that works with Postgres Plus Advanced Server.

 

What is GridSQL?


GridSQL for Postgres Plus Advanced Server is a horizontal scale out architecture that enables organizations to easily meet complex Data Warehousing and Business Intelligence challenges at a fraction of the cost of traditional solution. GridSQL uses a true grid technology that implements a u339 shared-nothing u-3 , distributed data architecture. GridSQL for Postgres Plus Advanced Server enables OLAP applications to leverage the power of multiple commodity servers while appearing as a single database to the application. GridSQL enables enterprises to:
  • Quickly and easily create, maintain, and access very large databases for Business Intelligence and Data Warehousing applications
  • Offload reporting from expensive hardware platforms onto an inexpensive grid of commodity hardware, creating significant savings
  • Run reporting and other applications with very large datasets, improving organizational decision-making
  • Improve organizational productivity and agility by enabling quick access to large amounts of information
  • Provide linear horizontal scalability.

What Programming Languages does Postgres Plus Standard Server support?


PL/PgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java®, PL/PHP, PL/Py (Python), PL/R, PL/Ruby, PL/Scheme, and PL/sh (Unix Shell).

 

What platforms do Postgres Plus servers support?


Standard and Advanced Server both support Linux® x86/32 and x86/64, Windows®, and Mac OS® X. In addition, Advanced Server supports Solaris® x86/64 (Intel®), and Solaris SPARC®.

 

What are the maximum sizes/capacities of a Postgres Plus server databases? E.g. Maximum table size, etc?


  • Maximum Database Size is Unlimited
  • Maximum Table Size is 32 TeraBytes (TB)
  • Maximum Row Size is 1.6 TB
  • Maximum Field Size is 1 GB
  • Maximum Rows per Table is Unlimited
  • Maximum Columns per Table is 250 - 1600 depending on column types
  • Maximum Indexes per Table is Unlimited

Do Postgres Plus servers work with Hibernate?


Yes, we have certified with Hibernate. You would use the PostgreSQL dialect when configuring Hibernate.

 

What type of locking model do Postgres Plus servers have?


Postgres Plus Advanced Server uses Row Level locking with non-escalating locks.

 

What isolation level(s) do Postgres Plus servers support?


Read Committed by default. We can also support Repeatable Read and Serializable.

 

Do Postgres Plus servers support connection pooling?


Yes, via pgpool which is a connection pooling/caching mechanism for PostgreSQL and Postgres Plus Advanced Server.

 

Do Postgres Plus servers support LOBs?


Yes, both blobs and clobs are supported.

 

Do Postgres Plus servers have a Perl driver?


Yes, the PostgreSQL driver will work fine except in the case of calling stored procedures with OUT/INOUT parameter in Postgres Plus Advanced Server. In that case the Perl can utilize our ODBC driver for calling stored procedures with OUT/INOUT parameters.

 

Do Postgres Plus servers support Ruby?


Yes, via the PostgreSQL driver.

 

Do Postgres Plus servers support Varrays and table collections?


Postgres Plus servers v8.4 supports table collections. Varrays are supported as a simple bounded table collection.

 

More Frequently Asked Questions...


Still have more questions? See All Frequently Asked Questions.