White Papers

White Papers

Best Practices with Postgres Advanced Server

Learn how EDB Postgres Advances Server reflects better engineering practice for three recurring enterprise problems: leaving Oracle without destabilizing rewrites, enforcing security where the data actually lives, and operating Postgres predictably at scale.

Omni-Data AI on Postgres

Learn how EDB Postgres (PostgreSQL as packaged and supported by EDB), combined with pgvector and EDB Postgres AI Factory AI Pipelines, provides an omni-data foundation in which relational records, JSON documents, and vector embeddings are stored and queried together.

Oracle Database Migrations to EDB Postgres

This comprehensive best-practices guide provides an industry-standard approach for migrating enterprise Oracle databases to EDB Postgres Advanced Server, leading IT professionals through the complete migration lifecycle from initial assessment to production cutover.

Non-Oracle Database Migrations to EDB Postgres

This best-practices guide provides a comprehensive, industry-standard architecture for migrating enterprise applications and data from non-Oracle databases—specifically Microsoft SQL Server, CockroachDB, and MongoDB—to EDB Postgres.

A Best Practices Guide to EDB Postgres Performance Optimization and Scaling

Achieving optimal performance and scalability with EDB Postgres is not an isolated database administration task; it is a holistic engineering discipline that begins with the foundational layers of hardware and the operating system.

Best Practices for High Availability and Disaster Recovery

EDB Postgres leverages a combination of enterprise-grade tools and architectural designs to ensure high availability (HA), disaster recovery (DR), and comprehensive backup and recovery.