[146]

That's really interesting to know, actually. I've only been with companies that had MySQL installations (Facebook and Twitter) and so jumping in was really easy, but on the other hand I do like to do things right. A few questions, though:

0/ How would I be able to tell if the limitations of our DB are because of MySQL and would be solved by PostgreSQL? That is, common pain points in MySQL that we wouldn't recognize immediately until we switched? (Edit: mostly looking for performance-related, but anything is fine.)

1/ Is there a PostgreSQL consulting firm that has the same reputation that Percona does with MySQL?

2/ Is there a good place to start when there's an issue or question I have with PostgreSQL (aside from IRC)? With MySQL I've been either going to the docs, or to Google, but it's been spotty with either.

[thristian]

0: Empact lists a few here: http://news.ycombinator.com/item?id=1547192

1: There are a number of highly trusted PostgreSQL consulting firms; the last time my employer needed a consultant, we hired one from Fujitsu's dedicated PostgreSQL team.

2: So far, I've only needed the (deliciously comprehensive) PostgreSQL online docs and (sometimes) Google; most Google searches wind up on the official user/developer mailing-lists, so that would be another good place to ask.

[piotrSikora]

http://www.postgresql.org/support/professional_support is good place to look for consulting firms.

Both http://www.pgexperts.com/ and http://www.enterprisedb.com/ are run by core PostgreSQL developers.

[jdagostino]

for the consulting firm question http://www.enterprisedb.com/ and http://www.commandprompt.com/ are large contributors to postgres and have great mindshare in the community

[niklas]

re 2: The mailing lists http://www.postgresql.org/community/lists/ are a good place to ask questions. Core devs are frequently answering questions there.