Blog Posts by

Dynamic Columns (Dynamische Spalten)
Apr 10, 2013
Sql has never been good at handling dynamic columns — it can easily process tables with a fixed number of columns, but dynamic column handling has...
Creating Virtual Columns
Apr 1, 2013
Databases store data in table columns, but sometimes it is useful to create non-storage columns for code clarity. For example, you might need to...
Pg_Upgrade Bug with Invalid Concurrently-Created Indexes
Dec 14, 2012
Postgres, since version 8.2, has supported the ability to create indexes without blocking writes (insert, update, or delete) on the table being...
Monitoring Postgres from the Command Line
Aug 6, 2012
You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for...
What Are Oids
Jun 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...
Cluster, Cluster, Schema, Schema
Jun 4, 2012
There are 500k to 1-million words in the English language, so you would think that Postgres would be able to find a unique word for every aspect of...
The Effectiveness of effective_cache_size
May 4, 2012
Friday, May 4, 2012 Having reported the methods for finding the size of the kernel cache on Linux, I wish to highlight the importance of the...
When to Use Multiple Clusters, Databases, or Schemas?
Apr 23, 2012
*/ I previously explained that Postgres allows multiple databases per cluster. The outstanding question might be, when should I use multiple clusters...
Limiting Postgres Connections
Feb 24, 2012
Friday, February 24, 2012 During recent training , I realized there five ways to control who can access Postgres, and it isn't totally clear in the...
Sorting Performance Improvement for Postgres 9.2
Feb 16, 2012
As part of the work on Postgres 9.2, yesterday Robert Haas applied a much-discussed ( December , January , February ) patch by Peter Geoghegan to...
Virtualizing Postgres
Feb 9, 2012
Postgres is an ideal database to run in a virtual environment or public/private cloud — one reason is that Postgres relies heavily on the operating...
What Is a GUC Variable?
Dec 1, 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...
Database Reliability
Aug 4, 2010
Wednesday, August 4, 2010 The database is usually a critical piece of infrastructure in an organization; when the database is down, many things stop...