The EDB Blog

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

Richard Yen

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

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

Richard Yen Apr 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...

Identify and Resolve Problems Faster by Logging PostgreSQL Activities

Identify and Resolve Problems Faster by Logging PostgreSQL Activities

Richard Yen Apr 20, 2020

The 18th Southern California Linux Expo (SCaLE) took place in sunny Pasadena California in March, which included a 2-day series of talks by members of...

Why hot_standby_feedback Can Be Misleading

Richard Yen Mar 19, 2019

Introduction When I first got involved in managing a Postgres database, I was quickly introduced to the need for replication. My first project was to...

PgBouncer Pro Tip: Use auth_user

Richard Yen Dec 18, 2018

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep...

Making Postgres Talk to LDAP (with StartTLS)

Making Postgres Talk to LDAP (with StartTLS)

Richard Yen Feb 27, 2018

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } I recently got a few support cases from...

Be Sure to Stop Your Backups!

Richard Yen Dec 12, 2017

This article is about using pg_stop_backup() when setting up Streaming Replication. It is not an article about backup/restore methodology or policy...

4 Steps to Using UUIDs with JPA in PostgreSQL

Richard Yen Feb 9, 2016

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Postgres supports a variety of data types...

Solving Cache Line Contention in Large NUMA Systems

Richard Yen Jan 20, 2016

EnterpriseDB® (EDB™) works with a significant number of global brands that deploy EDB Postgres to support complex business-critical workloads. Some of...