News, articles, customer success stories, and tutorials on PostgreSQL, open source, EDB, and more
Timing is Everything for Trading Applications: Don’t Lose with Database Extreme High AvailabilityEDB Team—11/21/2022
The world of online trading platforms is allowing more people to take control of their financial futures and creating new opportunities for innovation among application and platform providers. In order to compete, however, these providers need to have a database that can keep pace with the demands of the industry and expectations of their users.
Modern Database Strategies Survey: Why Executives Have Everything to Gain by Moving to PostgresEDB Team—11/18/2022
If, like these executives in the survey, you want to eliminate vendor lock-in and increase scalability by moving to open source, don’t let a perceived lack of Postgres knowledge hold you back! Our fully managed Postgres in the cloud service handles database maintenance for you, so you can focus on business innovation.
How to use an external database for pgAdmin user settingsAkshay Joshi—11/18/2022
The purpose of this blog is to illustrate how to save pgAdmin 4 configurations to an external database server. In addition, we covered examples that demonstrate how to use PostgreSQL server as an external database.
Critical Capabilities for Cloud Database Management Systems for Analytical Use Cases – Gartner® ReportCecilia Aceti—11/15/2022
Gartner's extensive “2021 Critical Capabilities for Cloud Database Management Systems for Analytical Use Cases” report is designed to help organizations evaluate the strengths and weaknesses of both native services offered by CSPs and fully cloud-based systems.
Listening to Postgres: How LISTEN and NOTIFY Syntax Promote High Availability at the Application LayerShaun Thomas —11/8/2022
Postgres provides several tools to simplify application development. Triggers, for example, allow one event to automatically invoke subsequent inserts, updates, or deletes to either reinforce business logic, or for auditing purposes. But are they valid for all such scenarios? Are there times when triggers would be detrimental to performance and scalability? What are our alternatives? Well, there’s only one way to find out!
Oracle Migration Webinar Recap Part 3: EDB Customer Success StoriesCecilia Aceti—11/7/2022
In the third and final part of this series (viewable on-demand), EDB’s Performance Engineering and Architecture Team VP, Vibhor Kumar and Solutions Architecture VP, Gianni Ciolli present real-life migration success stories, demonstrating how three different EDB customers successfully migrated from Oracle to Postgres.
Cloud Usage Survey: The Results Are In From Microsoft IgniteChristina Wong—11/1/2022
Microsoft recently held their annual Ignite Conference as a primarily online event, with an in-person presence in select cities around the world. We asked Microsoft Ignite attendees about their cloud usage and the benefits they expect from fully managed databases. Read on to see the results.
New Public Schema Permissions in PostgreSQL 15Peter Eisentraut—10/31/2022
Each database contains a schema named public by default. This schema is also by default part of the search_path. The effect is that if you don't specify any schema in any commands, all the activities take place in this public schema.
Oracle Migration Webinar Recap Part 2: Tools and Resources to Ease Oracle to Postgres MigrationCecilia Aceti—10/28/2022
When we surveyed our customers in 2020 and asked them what they saw as obstacles when migrating from Oracle to Postgres, cost was their smallest concern, followed by migrating the database definitions, migrating the stored procedures and moving from proprietary drivers to Postgres open source drivers. Their largest concern? Migrating the data.
The MERGE Command Has Finally Arrived in Postgres 15!Vik Fearing—10/27/2022
MERGE is the kind of thing we heard about for a long time before it was really implemented into PostgreSQL. According to Postgres wiki, the first time a contributor asked about this feature is as old as November 2005! We thought for a while we would see it in Postgres 14, but it was finally pushed back to Postgres 15.
Harnessing Shared Buffers - Part 2Shaun Thomas —10/26/2022
In Part 1, we examined how Postgres behaves on older hardware with various allocations of Shared Buffers. This time we repeat those benchmarks on more contemporary hardware equipped with modern SSD storage. The difference this makes is dramatic and has far reaching implications. Join us as we discuss the continuing role of Shared Buffers in modern server deployments!
Release Radar: Apache Superset® is Now Available in BigAnimalNatalia Wojcik—10/26/2022
Starting today you can explore your data in BigAnimal using Apache Superset’s rich visualizations. Available upon request, Apache Superset® is an easy-to-use enterprise business intelligence tool that can process large amounts of data, turning them into charts and graphs.
5 Reasons Why Postgres is the Most Widely Adopted Open Source Database in GovernmentJeremy Wilson—10/25/2022
While legacy, proprietary database providers have been an industry mainstay in the past, mission leaders in government are increasingly recognizing the constraints that these systems impose on their organizations—especially when it comes to control over their own data.
You Can Now Pick Your Favorite Compression Algorithm For Your WALs!Julien Tachoires —10/24/2022
Since version 9.5, PostgreSQL offers the possibility to compress WAL records (when full-page writes are enabled) via the wal_compression parameter. Before PostgreSQL 15, when WAL compression was enabled, only one compression algorithm was available: pglz.
Migration Conversation: 4 Vital Questions to Ask to Ensure a Successful Postgres MigrationMatthew Lewandowski—10/21/2022
In order to fully harness all of Postgres' potential, however, it’s important to start thinking about the process of migration as early as possible. Ensuring a successful move from Oracle to Postgres starts long before your data starts leaving the Oracle environment.
Postgres 15 Adds Copy Header and MatchingBruce Momjian—10/20/2022
Postgres 15 is out, with 183 new features and changes. Many of these features are major, but we always try to highlight one feature that is simple and useful. For Postgres 15, we have chosen additions to the copy command for text output and verification of copy headers.
Exclusive Backup Mode Finally Removed in Postgres 15Stefan Fercot—10/17/2022
The exclusive backup mode was deprecated since PostgreSQL 9.6 when non-exclusive backups were introduced. PostgreSQL 15 finally removes that long-deprecated feature and, to avoid any confusion, renames the pg_start_backup() and pg_stop_backup() functions to pg_backup_start() and pg_backup_stop().
How to Set Up Streaming Replication to Keep Your PostgreSQL Database Performant and Up-to-DateManish Yadav —10/12/2022
Streaming replication is a core utility of PostgreSQL introduced in version 9.0. Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping.
BigAnimal: Fully managed PostgreSQL in the cloud
BigAnimal features Oracle compatibility, built-in high availability, and 24/7 support from our team of PostgreSQL experts.Learn more
Demo of Oracle SQL compatibility in BigAnimal
BigAnimal lets you run Oracle SQL queries in the cloud via EDB Postgres Advanced Server. Watch the video, or load up psql and follow along.Learn more