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 show someone how to store a UUID (Universally Unique Identifier) into Postgres by way of JPA (Java Persistence API).

Contributed by Gary Carter Organizations can reduce their database spend by 80% or more by deploying EDB Postgres in place of traditional database solutions like Oracle, according to calculations in a recent Gartner report. But while the benefit of redirecting money saved is often crystal clear, the risks associated with migrating databases prevent many organizations from trying. These risks...

The Dutch federal government completed a major overhaul last year of its public health care and services systems. In the overhaul, many of the organizational responsibilities of national systems were assigned to local providers. To handle the demands of myriad new responsibilities, many local governments had to build or implement new solutions.

The newest version of EDB Postgres Advanced Server® merges the recently released community version of PostgreSQL with EDB’s enterprise-class, open-source-based database. EDB Postgres Advanced Server is complete with additional performance, security and management capabilities.

Released January 7, the new PostgreSQL 9.5 ushered in a host of new features and capabilities that boost performance, scalability and data analytics productivity.

EnterpriseDB® (EDB™) works with a significant number of global brands that deploy EDB Postgres to support complex business-critical workloads.

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 some compelling directions for IT professionals on their road to open source. Their advice? Adopt an open source relational database as a standard for new applications and for migrating those that don’t need special capabilities.

The release of PostgreSQL 9.5 marks a turning point for enterprises using PostgreSQL for the development of high-speed mobile, web and digital economy applications, many for customer engagement.

The number of open source software users is rising – and as Dries Buytaert, founder of Drupal and champion of OSS famously said, “The numbers don’t lie.”

Parallelism is now a reality in PostgreSQL. With 9.6, I hope we will see many different forms of queries that can use parallelism to execute. For now, I will limit this discussion to what we can already do, which is Parallel Sequential Scans.