My company, Trusted Network Technologies, embeds the Postgres (sorry, I just can't get used to calling it PostgreSQL) database in our system. We use Postgres to store our configuration data, but we mainly use it to store security audit data. Since our system collects security audit data for connections we see on the network, certain tables in our database can obviously get real large real fast (one of our customers captures about 100gig every week). So we need fast insert, reliability, and then we need fast query on very large data sets.
A few months ago, we decided to use the new commercial Postgres company, EnterpriseDB. They've assembled many of the Postgres technical leaders, and they offer a fully tested and supported version of Postgres with some improved features and utilities, plus consulting and support. We decided to use them because we had struggled ourselves with a few support issues related to Postgres, and we wanted a more direct way to tap into Postgres experts to make sure our system was fully tuned.
Our first few months with EnterpriseDB have been great. We've received excellent advice on tuning our system, and we expect it to show huge dividends in upcoming releases. For anyone shipping a product with an open source database, take a good look at EnterpriseDB. They're also trying to compete with Oracle inside the enterprise, and frankly I don't see why they shouldn't be strongly considered there too. If you're already using Postgres for any business, then picking up support from EnterpriseDB seems like a no-brainer to me.