The EDB Blog

Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Keith Alsheimer
The sharpest minds in data management gathered for Postgres Vision 2017 this week in Boston to begin shaping a future with open source for harvesting strategic value and actionable insight from data. The first day of discussions spotlighted open source gains in artificial intelligence, strategies for achieving enterprise agility, and challenges in...
MORE
By ahsan hadi
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile, web, and machine sources. The sheer volume of data can limit the number of backups DBAs can perform, increasing the importance of creating defined data retention policies in the database platform...
MORE
By Bruce Momjian
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 single null in such cases. Users migrating from other database systems sometimes want to emulate this behavior in Postgres. Fortunately, this can be done. First, let me show the default Postgres...
MORE
By Ashutosh Bapat
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 years. During PGCon 2017, it was a hot topic of discussion. People wanted to know more about the feature, and were eager to try it out. The unconference and conference session on partitioning attracted...
MORE
By Debra Brucato
In a 2013 McKinsey & Company global survey, 35 percent of executives said improving the talent level and capabilities of IT staff was critical for improving the performance of major IT projects. This number reflects the challenge organizations face: just as the emphasis has shifted to becoming a digital enterprise, a major priority has become...
MORE
By Bruce Momjian
You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight modifications. For example, you cannot create a table called all: CREATE TABLE all (x INTEGER); ERROR:  syntax error at or near "all" LINE 1: CREATE TABLE all (x INTEGER...
MORE
By Thomas Munro
(This blog was co-written by Sunil Narain.) Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data protection in case of disaster, or if a server or data center goes down. Synchronous replication does come with a performance penalty, which is why many people use the default asynchronous...
MORE
By Vibhor Kumar
In the world of solution architecture, where we as solution architects are developing configurations to meet specific customer needs, we often consider a great deal of interesting scenarios. One of such scenario my team at EnterpriseDB® (EDB™) encountered recently bears exploring further with this blog. For a business critical application,...
MORE
By Robert Haas
In a talk which I gave at PGCONF.IN and, in a shorter version, at PGCONF.US, I had a few slides on who contributes to PostgreSQL development.  Here, I'd like to present a slightly expanded version of the information which was in the talk.  The information in this post considers calendar year 2016 and comes from two sources. First, I went through...
MORE
By Bruce Momjian
Postgres uses native cpu alignment to store values in a row. This allows blocks to be copied unchanged from disk into shared buffers and accessed as local variables, as outlined in this presentation. This can be illustrated by pg_column_size(). First, an empty row size: SELECT pg_column_size(row());  pg_column_size ----------------             ...
MORE