young guy wanting (Postgres DBA) ammo

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: young guy wanting (Postgres DBA) ammo
Date: 2007-11-02 04:03:46
Message-ID: 472AA1A2.3030307@earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hiya list,

A friend recently told me that, among other things, the institutions for
which he works tend to choose MySQL or MSSQL over Postgres because the
latter requires a dedicated DBA while the former do not. When they do
spring for a DBA, they go with Oracle. As a developer/end-user in/of
the MySQL/Postgres/Oracle environments, I can say hands down that I
prefer Postgres and I have a list of reasons why to which I can readily
refer.

However, I'm not a DBA and only minimally know what's involved in doing
the job, so I don't have "ammo" to defend (or agree?) with my friend
when he says that "Postgres requires a DBA and MySQL doesn't so that's
why they choose the latter." Basically, I have so far not run across
the need to mess with any of the tunables. (I am naive, I know.)
Clearly, one should generally pick the best tool for the job, so I'm no
pundit that Postgres is *always* the right answer, but I'd like to be
informed. My questions:

- With 8.2, and the almost-out 8.3, what kinds of responsibilities
should a Postgres DBA expect to have?

- More in line with the conversation with my friend, what/why is it that
Postgres needs a DBA while MySQL doesn't? I highly suspect that the
assumption that MySQL doesn't need a DBA is incorrect, but that's what
was posed to me and I couldn't agree or disagree.

I am familiar with Greg Smith et al's page:
http://www.postgresql.org/docs/techdocs.83

Thoughts? Thanks in advance,

Kevin

P.S. BTW Greg et al, thank you a *ton* for putting that document
together. I learned a lot watching the discussion on the list and
reading the final version.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-02 04:35:40 Re: young guy wanting (Postgres DBA) ammo
Previous Message Scott Marlowe 2007-11-02 03:32:47 Re: Improve Search