The EDB Blog

The latest thought leadership pieces from EDB, including company and PostgreSQL announcements

Postgres Pulse Insights

​​5 Common Challenges for New Arrivals to PostgreSQL in the Cloud

5 Common Challenges For New Arrivals to PostgreSQL in the Cloud

Jamie Watt August 18, 2020

“The cloud” feels like it’s been a thing for about, well, forever at this point. Yet, we see many customers who are just beginning to explore their...

Maintaining PostgreSQL

Maintaining PostgreSQL is More Than Just a Maintenance Plan

Deepanshu Sharma July 24, 2020

“We need to attain ZERO downtime and high performance in our application,” I was told during a conversation with a manager of a line of business...

Postgres Pulse Insights

Should You Ever Use Synchronous Replication in PostgreSQL?

Jamie Watt July 2, 2020

A PostgreSQL Database Failure and a Failover A customer reached out to the Support team on a random Tuesday, some months ago. They had experienced a...

PostgreSQL Support: Why Is It So Important?

PostgreSQL Support: Why Is It So Important?

Jamie Watt June 12, 2020

Open source and purely commercial databases have been living together for a long time, but the open-source model continues to gain more and more...

PostgreSQL Write-Ahead Logging (WAL) Tradeoffs: Bounded vs. Archived vs. Replication Slots

PostgreSQL Write-Ahead Logging (WAL) Trade-offs: Bounded vs. Archived vs. Replication Slots

Thom Brown May 28, 2020

This week, a customer I was working with wanted help setting wal_keep_segments—the number of extra transaction log files to keep on the primary...

EXPLAIN ANALYZE

How to Use EXPLAIN ANALYZE for Planning and Optimizing Query Performance in PostgreSQL

Richard Yen April 30, 2020

With many people working from home these days because of the coronavirus pandemic, it can be a little challenging to get help from a colleague...

Postgres Pulse Insights

“Sorry, too many clients already” - How to Use PgPool to Solve Database Connection Load Problems

Piyush Sharma April 16, 2020

With the ongoing crisis of COVID-19, I keep myself updated with the latest situation around the globe. The WHO’s website is one I’ve used frequently...

Postgres Pulse Insights

"I can’t get to the database! Is it down?" PostgreSQL LDAP Authentication Problems

Jamie Watt April 9, 2020

The morning begins with a new email, with this subject line at the top of the inbox of you, the trusty DBA. The database isn’t down, though, otherwise...

Graphic with gears

Postgres Pulse Insights: It’s Still Slow! - Solving the Bloated Postgres Database

Ankit Shukla April 3, 2020

Welcome to this week’s Postgres Pulse Insights, where we answer vital Postgres questions and provide key tactics for DBAs on how to overcome common...

Postgres Pulse Insights

Introducing Postgres Pulse: Insights & Live Q&A with Postgres Experts

Marc Linster March 25, 2020

We get numerous tech issues and common database symptoms flagged to our team on a daily basis. And given the current landscape fraught with...