As the primary organizer of The PostgreSQL Conference series, Command Prompt has been trying to find ways to continue to support the PostgreSQL Community. The Conference is already the highest direct financial contributor but the money isn't always what the community needs. The documentation may need some work (pg_dump section I am looking at you), we might want server to execute performance testing or there are features that the …
Blog
Netflix should tell 6,000 users to please cancel their accounts
Today, Netflix upped its rates. It was not an excessive increase (dollar wise) but it was enough to get some masses frothing at the mouth [1]. Here is the deal folks, Netflix is cheap, really cheap. It is so cheap that their selection is dwindling as their contracts become due. To get even close to the equivalent service from a cable company you would be looking at upward of 100.00 …
Real-world example of adding SAML authentication to a JBoss application
What is SAML?
SAML stands for Security Assertion Markup Language. It's an XML-based markup language and also an open security protocol standard. The most important feature of this protocol is Web Browser Single Sign-On (SSO.) SSO allows users to login once and never be prompted for login/password later.
In this post we'll describe how to add SAML support to existing web application with the bare minimum of modifications to the …
Actually, I am going to #PgWest (and you might not want to)
OK, I am just trying to set the record straight. People are still confused thinking I might not be going to #PgWest, but I am. I know where the confusion comes from; there are a few other conferences going on during that time frame but the only two that matter are #PgWest and Surge. So, to be clear, I will be going to #PGWest this year not Surge. …
#PgWest 2011: CFP Open
Following on the smashing success of PostgreSQL Conference East, PostgreSQL Conference West, The PostgreSQL Conference for Developers, End Users and Decision Makers, is being held at the San Jose Convention Center, in San Jose, CA from September 27th - 30th. Please
join us in continuing to make this the largest PostgreSQL Conference series in North America.
- Main site.
- Call for papers
Time line:
May 25th: Talk submission opens
July 31st: …
PGCon 2011 Developer's Meeting picture
For those that are curious (and which for some reason don't follow the #pgcon tag at twitter), here's a picture of the attendees of Developer's Meeting.
Back row, from left to right: Robert Haas, Selena Deckelmann, Marko Kreen, KaiGai Kohei, Stephen Frost, Magnus Hagander , Robert Treat, Tom Lane, Heikki Linnakangas, Mark Wong, Josh Berkus, Kevin Grittner, Dimitri Fontaine, Koichi Suzuki, Andrew Dunstan, Fujii Masao, Jeff Davis, Greg Smith, Tatsuo …
PgWest 2011: San Jose Convention Center, September 27th-30th
I am currently at the Gartner BI conference (yes really), so I won't have time to announce officially until later this week but I have had a lot of people asking me about when West will be. So, here ya go. San Jose, September 27th-30th at the convention center. The conference is already set up at Lanyrd if you want to get social.
The website is not quite updated yet …
An attempt at finding glaring btree problems
Some time ago, a customer came to us with a strange vacuuming problem. Their regular vacuum job would die with a message such as this one:
vacuumdb: vacuuming of database "clint_app" failed: ERROR: failed to re-find parent key in index "work_items_pkey" for deletion target page 6100
Eventually, it turned out that their storage firmware had some glitch that caused things to go wrong in random ways, and corruption in various …
This is what table bloat looks like
I got curious about a bloat problem on a customer's system today. The statistics as calculated by normal tools/queries say that one of the tables is 2x bloated. Another table is 6x bloated. And so on. For some reason I wanted to see what it looked like in a graphical way, so I threw together this simple query:
select s, coalesce(count, 0)
from (select block, count(*)
from (select split_part(tid, ',', …Our company, EnterpriseDB, is the commercial company that brings to market the open source Postgres database., Ed Boyajian.
I tend to spend a lot of my time reviewing what is going on in the wider PostgreSQL ecosystem. Over the past few months I have been increasingly intriqued at a overriding theme that is starting to emerge in the market. That "EnterpriseDB" is "The PostgreSQL Company". This isn't about taglines but actual perception in the market.
I was speaking with an individual from 10Gen (#PgEast Gold Sponsor and creator …