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.
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 |