The EDB Blog

Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Robert Haas
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 through.  (If you're not already familiar with the...
MORE
By Robert Haas
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't read part one already, please click on the link...
MORE
By Robert Haas
Have you ever had one of those annoying problems where a query, or some kind of maintenance task such as vacuum, seems to hang, without making any discernable foreign progress, basically forever?  If it's a foreground task, you typically think to yourself "oh, that's taking longer than normal" - but then you start to become suspicious as to...
MORE
By Robert Haas
A recent poster to the pgsql-performance mailing list enquired as to the relative performance of Microsoft SQL Server vs. PostgreSQL.  It's a reasonable question.  Switching databases can be a major project, and you certainly wouldn't want to do it and then find out at the end that you'd taken a huge performance hit and had to throw all your work...
MORE
By enterprisedb enterprisedb
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 lots of different platforms. And throughout my long career (man, I feel old saying that...) and the various tech shifts (mainframe, client/server, web, etc.) that have occurred, every now and then you'...
MORE
By Bruce Momjian
Wednesday, August 4, 2010 The database is usually a critical piece of infrastructure in an organization; when the database is down, many things stop working, so database reliability is often a serious concern. While the reliability of database software is important, for Postgres it is often the infrastructure that Postgres depends on that causes...
MORE
By Robert Haas
In a recent blog post on Gigaom, Simeon Simeonov argues that virtualization is on the way out, and discusses VMware's move toward platform-as-a-service computing. In a nutshell, his argument is that virtualization is inefficient, and is essentially a last resort when legacy applications can't play nicely together in the same sandbox. In other...
MORE
By Dave Page
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 this post I'll explain what the passwords are, why we need them, and how to reset them. Superuser Password The Superuser Password is used by Postgres to secure the built-in "postgres" superuser...
MORE
By enterprisedb enterprisedb
Recently, I've been digging into Scala to understand how PostgreSQL would integrate inside of Scala code. Scala is an interesting language which runs on the JVM like Java but eliminates much of the Java boiler plate code increasing the productivity of developers. With many of the knowledgeable Java programmers advocating Scala and large success...
MORE
By Dave Page
I've been asked a few times recently for my opinion on VoltDB, the new database server architected by the 'father' of Postgres, Dr Michael Stonebraker so rather than repeating myself over and over again it seems like a good idea to write it all down. VoltDB is an in-memory, lockless relational database that maintains ACID compliance, has a SQL...
MORE