PostgreSQL (Postgres) Community

Postgres - Blog

Porus Homi Havewala
Follow /17 Oct 2017 at 8:24pm / Postgres - Blog

PostgreSQL Database for Enterprises – Part I

In today’s brave new world, data and information of all sorts are rapidly proliferating. Many companies who have used traditional databases such as the Oracle database or Microsoft SQL Server for their data requirements since the 1990s have now...
286 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 8:11pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VIII

by Porus Homi Havewala In this eight-part article series, we have had a good look at Amazon AWS and its Relational Database Service (Amazon RDS), in particular Amazon’s own Aurora database with PostgreSQL compatibility. In the previous part VII...
851 0 /
zaheer.appsdba
Follow /29 Aug 2017 at 12:54pm / Postgres - Blog

PostgreSQL/EnterpriseDB Inside Linux Containers (LXC)

Introduction: Virtualization is one of the core assets of today’s data center infrastructure. The benefits and capabilities of virtualization are driving organizations towards virtualization technologies. Virtualization offers efficient utilization...
430 0 /
Porus Homi Havewala
Follow /2 Aug 2017 at 5:43pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VII

In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS); in particular, Amazon’s own Aurora database with PostgreSQL compatibility. We examined in detail the benchmark results...
670 0 /
Bruce Momjian
Follow /13 Jul 2017 at 12:51am / Postgres - Blog

Allowing Only One NULL

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 single NULL in such cases. Users migrating from other database systems sometimes want to emulate this...
374 0 /