The EDB Blog

PostgreSQL

PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

You Don't Need Every Feature of Your Previous Database
2017년 8월 8일

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
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
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
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
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...

Postgres Vision Training Day at MIT Ends with Certification
May 26, 2017

In a 2013 McKinsey & Company global survey, 35 percent of executives said improving the talent level and capabilities of IT staff was critical for...

Postgres Keywords
May 17, 2017

You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard...

Cheat Sheet: Configuring Streaming Postgres Synchronous Replication
May 10, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } (This blog was co-written by Sunil Narain...

PostgreSQL Indexes: Hash Indexes are Faster than Btree Indexes?
March 24, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } PostgreSQL have supported Hash Index for a...

Autovacuum 제어
January 9, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Unlike other database systems, Postgres...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

Top Authors
Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video co…
Vibhor Kumar is Chief Performance Architect wit…
Senior Vice President, Marketing Frank Days is EDB's Vice President of Marketing. He h…
Raghavendra Rao is a Managing Consultant in Professional Ser…
Phil has 25 years experience working with relational database systems and is a Senior Consultant…