EDB Postgres Advanced Server
An enterprise-grade relational database management system built on top of PostgreSQL.
Detailed Information
Performance
With partitioning, it is 75 – 450x times more performant than PostgreSQL. Ease of use with syntax instead of manual coding
Oracle Compatibility
High compatibility with PL/SQL and Oracle syntax support, data type compatibility, and the ability to replicate directly from Oracle.
Super Economy
You do not pay a licensing fee, your total cost of ownership (TCO) is much lower, and you are not dependent on a single vendor.
Scalable
With the support of professional equipment, you gain a highly scalable, geographically distributed, flexible, and robust infrastructure.
High Service Continuity
A service that guarantees 99.999% availability can experience no more than approximately 5.26 minutes of downtime per year. Since hardware failures may also occur, achieving such a high level of availability requires the database workload to run redundantly across multiple hardware systems.
With EDB Replication Server, you can choose the single-master or multi-master replication option that best suits your needs. Whether your goal is improved performance, redundancy, or availability, EDB Replication Server makes it easy.
Let's discuss your needs.
PAS Security
Bulk SQL Operations
Performance can be improved in 100% and later versions by converting PL/pgSQL functions that handle large cursors and return massive result sets containing a large number of rows into SPL functions that use BULK COLLECT.
Code Profiler
The code profiling process is the execution of one or more procedural database code fragments to perform a performance benchmark and analyze where and how much time is spent during runtime.
Directory Consultant
Index Advisor recommends new indexes that should be created for more performant data scanning by analyzing one or more SQL statements to database experts and software developers.
EDB*Loader
Starting with the PAS 9.0 version, EDB*Loader has been granted the capability to simultaneously import data from multiple files into the same table, thereby achieving much greater gains in import performance.
Query Optimization Tips
Query Optimizer Hints allow software developers to contribute to how the query planner behaves while performing optimization.
SQL Profiler
SQL Profiler examines the selected database and generates a report of the SQL commands coming into it. The query profelis report is one of the greatest aids for database experts in improving the performance of their systems or software.
DynaTune
DynaTune™ is used to ensure the correct optimization of the database workload depending on the server hardware. It helps you by simplifying performance optimization, which is the issue DBAs struggle with the most.
Virtual Private Database
With Virtual Private Database, the most granular access control permissions can be configured using security policies. So much so that access permissions can be defined even for a single row and even for a single column of a row.
SQL Injection Protection
Postgres Advanced Server has SQL/Protect, providing an additional firewall at the database layer against SQL injection attacks, intended for use by DBAs and contributing to developers' protection methods.
Audit Logs
Postgres Advanced Server keeps audit logs. Thanks to database audit reports, database administrators, security experts, auditors, and managers can analyze database access and activities, and do not feel the need for additional tools during audits related to corporate compliance.
Code Generator
EDB*Wrap, provided by Postgres Advanced Server, automatically obfuscates and hides the server-side code you write. It both protects the code and serves as an additional security measure.
