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.

Postgres 10 is a Milestone Reflecting the Vitality of this Open Source Community
November 2, 2017

The world in which PostgreSQL operates today is very different from its origins in 1986. Where once PostgreSQL might have been considered an academic...

Materialized Views and Foreign Data Wrappers
October 31, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } You might know that Postgres supports...

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

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 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
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
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
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?
2017년 8월 31일

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

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…
Raghavendra Rao is a Managing Consultant in Professional Ser…
Ajay Patel is a Delivery Manager on the RemoteDBA team, supporting customers worldwide with both…
Senior Vice President, Marketing Frank Days is EDB's Vice President of Marketing. He h…