Blog Posts by

Announcing TPC-C.js; a Lightweight Implementation of TPC-C
Jul 23, 2014
I am glad to announce the beta release of TPC-C.js, which implements one of the most popular database benchmarks, TPC-C . It’s not a coincidence that...
Old-style Lock-in vs. Next-gen Database Federation with Postgres
Jul 17, 2014
Recent big data news showed finally there was some recognition by Oracle that enterprises might have more than one database vendor in their...
Postgres Hibernator: Reduce Planned Database Down Times
Apr 30, 2014
TL;DR : Reduce planned database down times by about 97%, by using Postgres Hibernator . DBAs are often faced with the task of performing some...
Postgres: The Open Database Foundation
Mar 12, 2014
A decade ago, most companies faced financial challenges related to the dot-com bubble burst. Today, we’ve just gone through what was likely the worst...
Introducing Postgres Hibernator
Feb 3, 2014
As it must have been obvious from my last post that I wasn’t really pleased by the amount of work needed to implement hibernation of Postgres shared-...
Hibernating and Restoring Postgres Buffer Cache
Jan 20, 2014
With the introduction of pg_prewarm extension in Postgres, it has become very easy to save and restore the contents of Postgres server’s buffer cache...
Understanding Postgres Parameter Context
Jan 7, 2014
Postgres' parameters have an associated context, which determines when that parameter can be changed. You can see the context of every parameter...
New Relic Plugin for Postgres and Postgres Plus Advanced Server
Jun 20, 2013
We’re unveiling today, through a partnership with application monitoring tools provider New Relic, a plug-in to ease and enhance the user experience...
Sample App Tour
Feb 23, 2012
In my last blog , I performed a very short DB migration from a local PostgreSQL installation to one running in the cloud. In this blog, I want to...
Going after load spikes and performance lulls with Postgres Enterprise Manager
Dec 2, 2011
Bruce Momjian recently did a blog on Postgres Monitoring tools. I want to point out a unique and useful feature of Postgres Enterprise Manager from...
Postgres Plus Advanced Server 9.0 Sneak Peek – SQL Server Replication
Apr 28, 2011
This post is the third in a series that takes a look at some of the exciting new features of Postgres Plus Advanced Server 9.0, which is currently in...
Will the Cloud obsolete the DBA?
Nov 12, 2010
I've had the privilege of being a database administrator for a long time, and have gotten the opportunity to work with many different databases on...
Scala PostgreSQL Access
Jul 8, 2010
Recently, I've been digging into Scala to understand how PostgreSQL would integrate inside of Scala code. Scala is an interesting language which runs...
Quick and Powerful Database with OpenOffice.org and Postgres
Jul 26, 2009
Unless you've been living under a rock for the past 3 years, you've heard of OpenOffice.org. Like most people, I've used the software a few times to...