The EDB Blog

Tuning shared_buffers and wal_buffers

03/14/2012
I spend a lot of time answering questions about PostgreSQL, and one of the questions I get asked frequently is: how should I set shared_buffers? And, a bit less often, how should I set wal_buffers? I've got canned answers that I can rattle off so fast it'll make your head spin. Exceptions to my...

Limiting Postgres Connections

02/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 documentation how they fit together. There are basically a series of gates that users must pass through to connect to a Postgres database. I thought I...

Sample App Tour

02/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 share the small "wine database" application that I used. All of the code is available in this zip file , including a pom.xml file for building through...

Sorting Performance Improvement for Postgres 9.2

02/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 improve sort performance. Having recently blogged about how work_mem affects sort performance, I thought I would re-run my tests to see the improvement:...

Virtual Private Database (VPD) in PPAS 9.1

02/10/2012
Great News is Postgres Plus Advanced 9.1 is now available for users. So, I thought to write something about Virtual Private Database features, which is part of 9.1 Virtual Private Database (VPD) is a feature which enables Administrator to create security around actual data (i.e row/columns) so that...

Virtualizing Postgres

02/09/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 system, rather than using features like raw devices. Second, its license is obviously very flexible for virtual deployments. I am often asked about...

What Is a GUC Variable?

12/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 "Grand Unified Configuration", but the section it references doesn't mention the term "GUC" at all. Pretty obscure, huh? Our Grand Unified...

StackBuilder Package Updates

10/04/2011
If you've ever used one of the PostgreSQL installers for v8.2 or above, either the old Windows MSI installer or the newer "one click" installers that also support Linux and Mac, you'll probably have come across StackBuilder. For those that haven't or those that never found the time, StackBuilder...

Postgres Enterprise Manager; I love it when a plan comes together

08/22/2011
After 9 months of heads-down work, I'm glad to finally be able to talk about the project I and a number of colleagues here at EnterpriseDB have been working on... Introducing Postgres Enterprise Manager ! Postgres Enterprise Manager, or PEM as we tend to call it, is based on the Open Source pgAdmin...

PostgreSQL 9.1, meet MySQL

07/31/2011
So having spent the last few months with my head buried deep in a project at work, I finally managed to get back to my previous hacking on SQL/MED at the weekend after the kids went away for a week (good $DEITY it's quiet here)! Within a couple of hours, I had my half-baked Foreign Data Wrapper for...

Is this the Beginning of the End of Skype on PostgreSQL?

05/16/2011
True statement - Microsoft is now one of PostgreSQL’s largest users. Last week it was announced that Microsoft is buying Skype for a reported $8.5 billion in cash. What was not reported in this recent acquisition news cycle is an interesting fact -- Skype runs on the open source database PostgreSQL...

Postgres Plus Advanced Server 9.0 Sneak Peek – SQL Server Replication

04/27/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 beta. Before I came to EnterpriseDB, I was the director of product management for MySQL. During my five or so years at MySQL, I saw a lot of interest...

Oracle is abandoning HP-UX customers…Fight back!

03/27/2011
Last week, Oracle’s announced its decision to discontinue all software development on the Intel Itanium microprocessor . Apparently, Oracle contends that its decision was predicated on Intel’s “faltering commitment” to Itanium. The reporter surmises that Oracle wants HP's enterprise server money,...

Troubleshooting Stuck VACUUMs

03/01/2011
Over the years, I've occasionally encountered situations where VACUUM fails to make progress, and not fully understood why that was happening. Recently, I've come to a better understanding of how lock conflicts can result in VACUUM stalling out either at the beginning of the table, or part-way...

MySQL vs. PostgreSQL, Part 2: VACUUM vs. Purge

02/01/2011
Almost two months ago, I wrote part one of what I indicated would be an occasional series of blog posts comparing the architecture of PostgreSQL to that of MySQL . Here's part two. Please note that the caveats set forth in part one apply to this and all future installments as well, so if you haven'...