The EDB Blog

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

PostgreSQL

Use with Time Zone

Bruce Momjian October 3, 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...

PostgreSQL's Hash Indexes Are Now Cool

Robert Haas September 26, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Since I just committed the last pending...

PL/Java Adoption

Bruce Momjian September 19, 2017

PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java...

When to Use Server-Side Logic

Bruce Momjian September 12, 2017

The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The...

Which NoSQL Database for New Project?

Bruce Momjian August 31, 2017

Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones...

You Don't Need Every Feature of Your Previous Database

Bruce Momjian August 8, 2017

In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I...

Outer Joins and Where Clauses

Bruce Momjian July 19, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Postgres supports both traditional join...

Advanced Retention Management for Postgres Backups

ahsan hadi June 21, 2017

Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile...

Allowing Only One Null

Bruce Momjian June 14, 2017

While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. ms sql) allow only a...

ALTERing the Bounds of a Partition

Ashutosh Bapat June 12, 2017

PostgreSQL 10 is full with a lot of big, new and exciting features. Declarative partitioning is one of those. It is something users have wanted for...