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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
