EDB Tutorial: How To Contain Bloat with Partitions

PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables" ( slides). Last year, I had held an introductory...
March 27, 2018

Data Backup Made Easy

Backup strategies are critical to enterprise data management, but the time, storage, and management requirements pose a host of challenges.
November 16, 2016

4 Steps to Using UUIDs with JPA in PostgreSQL

Postgres supports a variety of data types that allow data architects to store their data consistently, enforce constraints through validation, maximize performance, and maximize space. Recently, I was asked to...
February 09, 2016

Driving the Open Source Road?

With nearly 10 million downloads over the past five years, Postgres is the leading enterprise open source database. In a report The State of Open Source RDBMSs, 2015,* Gartner gives...
January 15, 2016