Default Author

Richard Yen

Principal Software Development Engineer, EDB

Richard Yen is a Principal Software Development Engineer at EDB, focusing in PostgreSQL tuning, Database architecture, Software engineering, and DevOps. He used to be a web developer, then a DBA, then a Support Engineer, and now a DevOps engineer. Currently, he works on internal tools for EDB to help consolidate and streamline the development lifecycle. His team hopes that the tools we make will help achieve velocity and quality metrics for the company.

Read Blogs

Postgres Tutorials

PostgreSQL and Golang Tutorial

How to use PostgreSQL with Golang: This article covers how to use PostgreSQL together with the programming language Golang (Go). After showing how to get started with Go’s Object Relational Mapper, it offers an example of setting up a PostgreSQL database using Go.
Postgres Tutorials

Why you should use Connection Pooling when setting Max_connections in Postgres

PostgreSQL is “The World’s Most Advanced Open Source Database,” and I believe it. In my 10+ years of working with it, it’s been solid, serving up data to SaaS loads of over 1000 queries per second, rarely going down, surviving all manner of accusations of corruption (which turned out to be software engineering error) and performance degradation (which turned out to be user error).
Postgres Tutorials

How to create and refresh data for materialized views in PostgreSQL

Most relational database systems provide the functionality to create a VIEW, which basically acts like a shortcut or macro.
Postgres Tutorials

How to use PostgreSQL with Laravel

This article covers how to use PostgreSQL together with the PHP framework Laravel to deploy web applications. After walking through the Laravel installation process it shows how to get started and create tables.
Postgres Tutorials

How to use PostgreSQL with Django

This article covers how to use PostgreSQL together with the Python web application framework Django. After walking through the Django installation process it shows how to get started creating a simple Django application.
Postgres Tutorials

What Happens When I Press Enter? -- EDB failover manager Switchover

EnterpriseDB Failover Manager (EFM) is a great tool to automate failover/switchover if you use Postgres' streaming replication feature. Not only do you get High Availability (HA), you can do so with just a few simple commands to make it all happen very quickly.
Postgres Tutorials

Using auth_method=hba in PgBouncer

PgBouncer is a great tool for improving database performance with connection pooling. I've been using it for many years, since it first became available in 2007. Since then, several improvements have been implemented, including the ability to use auth_type=hba, which implements a PG-like HBA authentication method similar to the pg_hba.conf format we're all used to.
Postgres Tutorials

How does VACUUM work in PostgreSQL

I recently had a customer who was trying to figure out why his VACUUM-for-wraparound was taking so long–he had a 6TB database, and the VACUUM had been running for over 4 days.
Postgres Tutorials

How to determine Single Master XDB replication lag

I recently had a few customers ask me about using a query for monitoring SMR XDB lag, so they can keep tabs on replication progress and set up notifications.
Postgres Tutorials

How to Deal with the Case of Stuck TransactionIDs in PostgreSQL

Postgres is up and running, and things are humming along. Replication is working, vacuums are running, and there are no idle transactions in sight. You poke around your logs and make sure things are clean, but you notice a little warning.