pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to configure and use shared...
This post discusses the performance comparison between EPRS(EDB Replication Server) and PGD(EDB Postgres Distributed). It compares the performance benchmark between both the products and presents figurative results of both under...
Would you use Postgres in a 1-billion transaction-per-day system? I have! It’s a sobering and rewarding experience that really reveals where Postgres shines. This article will explore a vintage 2011...
What exactly is the PostgreSQL query optimizer capable of? Are you experiencing its full potential, or just scratching the surface? We recently released Part 1 of our two-part webinar series...
Starting v9.2, PostgreSQL is providing native data type support for JSON objects. Subsequent releases introduced JSONB (binary formatted JSON objects) and many data manipulation functions for JSONs, making it a...
In EDB’s recent webinar, Explaining the PostgreSQL Query Optimizer Part 1, EDB Vice President and Postgres Evangelist Bruce Momjian broke down the importance of the PostgreSQL query optimizer: what makes...
Developing a frontend for a database can be a challenging task, especially when there are multiple runtimes / frameworks available for the language of your choice. We have been dealing...
Are you running the latest major version of PostgreSQL, released September 2022? PostgreSQL 15 brings with it a series of significant improvements made to performance, security and usability—just like each...
Tuning of the max_wal_size configuration parameter in PostgreSQL can have a profound effect on performance, but it's often overlooked or not given the priority it deserves in favour of other...
Each new major release of PostgreSQL comes with many new and exciting features, security enhancements, and performance improvements. But, what specific performance gains are seen when upgrading outdated database clusters...
