Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between Postgres Plus Standard and Advanced Servers?

April 26, 2017advanced Plus Postgres servers standard

0

Posted

What is the difference between Postgres Plus Standard and Advanced Servers?

1 Answer

0

Posted

Starting with the features 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 engine. Many of the features enhance performance such as: DynaTune, EDB*Loader, and Distributed Federated Queries. Advanced Server also includes the following high performance features not found in Standard Server: GridSQL pre-bundled, Infinite Cache, Asynchronous Pre-Fetch, Query Optimization Hints, DynaTune, and DRITA. For more sophisticated programming, Advanced Server includes built in packages, programmable Bulk Collect and Bulk Bind functions, explicit transaction control, and audit logging. Finally, Advanced Server provides a more sophisticated suite of tools including Postgres Studio with an enhanced debugger for in context application debugging, the DBA Management Server, the DBA Mon