PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

List user privileges in PostgreSQL/PPAS 11
July 29, 2012
*/ PostgreSQL has some useful functions which can be used to know about the privilege of a user on a particular Database object. Those functions are...
Monitor CPU and MEMORY percentage used by each process in PostgreSQL/PPAS 9.1
July 23, 2012
*/ PostgreSQL has pg_stat_activity view which can be use to get the session details. This view gives following information: 1. datid: database OID 2...
What Are Oids
June 13, 2012
Object Identifiers (oids) were added to Postgres as a way to uniquely identify database objects, e.g. rows, tables, functions, etc. It is part of...
What Is a GUC Variable?
December 01, 2011
Thursday, December 1, 2011 You might have heard the term "GUC" before, especially on the Postgres email lists. It is documented as an acronym meaning...
PostgreSQL vs. SQL Server: Performance Comparison
December 20, 2010
*/ A recent poster to the pgsql-performance mailing list enquired as to the relative performance of PostgreSQL vs. SQL Server. It's a reasonable...
Postgres, Passwords and Installers
July 28, 2010
By far the most common issues we see reported with the "one-click" PostgreSQL installers that we build here at EnterpriseDB are password related. In...