Blog Posts by

Moving Tablespaces
October 16, 2018
Tablespaces are designed to allow Postgres clusters to be spread across multiple storage devices. Create tablespace creates a symbolic link in the...
Client Row Access Control
October 08, 2018
Usually, the database administrator controls who can access database data. However, it is possible for clients to completely control who can access...
Security Cryptographically Authenticated Rows
September 18, 2018
When storing data in the database, there is an assumption that you have to trust the database administrator to not modify data in the database. While...
Summer School Tour Bus
The EDB Postgres Summer School Rolls On
August 22, 2018
I’ve come to the end of my time in Europe now and I thought I’d share some of the feedback I’ve received from EDB customers along the way. I’ve been...
EDB Postgres Summer School Tour
July 17, 2018
I have been in Europe now for more than two weeks meeting a number of our customers and PostgreSQL users at the EDB Postgres Summer School. So far I...
Intermediate Certificates
April 10, 2018
I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted...
Wal and Xlog
April 03, 2018
Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache...
Data in the Database vs. the File System
February 20, 2018
An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at what...
4 Tips for Postgres Administration
December 05, 2017
Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk...
PERCENT_RANK Vs. CUMM_DIST
November 14, 2017
During research for my Postgres Window Magic talk, I studied the unusual behavior of percent_rank and cumm_dist ( cumulative distribution ). The...
Storing the Original Time Zone
November 07, 2017
In a previous blog entry I suggested storing the original time zone offset in a separate column if clients need to know the stored time in the...
Materialized Views and Foreign Data Wrappers
October 31, 2017
You might know that Postgres supports materialized views and foreign data wrappers (fdw). Briefly, materialized views allow for queries to be...
Session State Failover
October 23, 2017
On the server side, high availability means having the ability to quickly failover to standby hardware, hopefully with no data loss. Failover...
Playing with IPv6
October 17, 2017
Now that everyone is using IPv6 ( ) it might be time to start playing with it. Postgres has had full IPv6 support for years, so Postgres is a good...
Odd Month Arithmetic
October 10, 2017
You might be aware of the interval data type, which allows mathematical operations on date, time, and timestamp values. This can lead to odd behavior...
Use with Time Zone
October 03, 2017
If you often use the timestamp data type, you might not be making full use of it. In these queries: CREATE TABLE tztest (x TIMESTAMP ); INSERT INTO...

Top Authors

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on Po...

Robert is Chief Architect, Database Server, employed at EnterpriseDB as well as a PostgreSQL C...

Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video ...

Ken Rugg is EDB's Chief Product and Strategy Officer and is charged with leading the company's...