The EDB Blog

Recent Posts
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...
Postgres 10 is a Milestone Reflecting the Vitality of this Open Source Community
November 02, 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
*/ You might know that Postgres supports materialized views and foreign data wrappers (fdw). Briefly, materialized views allow for queries to be...
Containers: Impossible to Ignore and Just Might Change Everything
October 25, 2017
Virtual machines are by far the most prevalent deployment model for data centers – close to 99%. What was once a revolutionary idea has transformed...
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...
Road Trip! Your Oracle Migration Journey Just Got Simplified
October 19, 2017
Licensing complexity, rising costs, and audit risk are motivating Oracle customers to jump start their migration efforts to alternative database...
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...
Power Your Digital Transformation with Application Innovation in the Cloud
October 05, 2017
Digital transformation has officially become the key to meeting modern customer expectations. Only two years ago, Don Butler, Executive Director of...
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

Bhavani Rao is a Senior Product Marketing Manager for EnterpriseDB, responsible for product me...

Jan is Director of Sales Engineering at EnterpriseDB. In this role Jan supports the DACH-regio...

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

Dr. Stonebraker has been a pioneer of database research and technology for more than forty yea...

John Dalton is Senior Director of Product Management, responsible for product strategy and man...