PostgreSQL

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

User Tip: Postgres Plus 9.4 and Global Temporary Tables
October 21, 2015
EnterpriseDB (EDB) customers who moved/migrated their database from Oracle to EDB’s Postgres Plus Advanced Server (PPAS) frequently ask for Global...
Postgres and Transparent Data Encryption (TDE)
August 13, 2015
*/ Security has always been a great concern of Enterprises. Especially, if you have crucial information stored in the database, you would always...
Hadoop to Postgres – Bridging the Gap
February 20, 2015
*/ This blog was co-written by Ibrar Ahmed. Advances in Postgres in recent releases have opened up opportunities for expanding features that support...
First Rule in Securing Postgres: Don’t Be Dumb
February 12, 2015
*/ A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a...
Monitoring approach for Streaming Replication with Hot Standby in PostgreSQL 9.3.
May 21, 2014
*/ The people using PostgreSQL and the Streaming Replication feature seem to ask many of the same questions: 1. How best to monitor Streaming...
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...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.