Postgres Plus Standard Server Frequently Asked Questions
What are the product maintenance and support lifecycle timelines for Postgres Plus Standard Server versions?
In general each version (change in number to the right of the decimal point) is supported for 3 years with an additional 2 years of extended End of Life (EOL). For specific version dates see the Platform Products Lifecycle page.
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: DynaTuner, 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 Oracler Replication console.
Do Postgres Plus servers support Partitioning?
Yes, it is a fundamental feature of the database and supports Range, List and Hash partitioning (GridSQLr).
Does Toadr from Questr 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/Javar, 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 Linuxr x86/32 and x86/64, Windowsr, and Mac OSr X. In addition, Advanced Server supports Solarisr x86/64 (Intelr), and Solaris SPARCr.
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.