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
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
By Dave Page
A colleague of mine (thanks Jimbo!) pointed me towards a benchmark comparison of Postgres 8.3.8 on RHEL 5.4 versus SQL Server 2008 R2 on Windows Server 2008 R2, performed and written up by Red Hat. I hadn't seen it before, so figured that maybe others hadn't either: http://www.redhat.com/pdf/rhel/bmsql-postgres-sqlsrvr-v1.0-1.pdf Can't wait for...
MORE
By enterprisedb enterprisedb
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 edit some documents and haven't really given much thought to it.  During one of my last plane trips, I decided that the small database I keep (in PostgreSQL) needed a facelift, err, well, a face...
MORE