Re: DBA Book - Not "postgresql book - practical or something newer?"
От | Roderick A. Anderson |
---|---|
Тема | Re: DBA Book - Not "postgresql book - practical or something newer?" |
Дата | |
Msg-id | 47AA03FA.7050705@acm.org обсуждение исходный текст |
Ответ на | Re: DBA Book - Not "postgresql book - practical or something newer?" ("Olexandr Melnyk" <omelnyk@gmail.com>) |
Список | pgsql-general |
Olexandr Melnyk wrote: > Joe Celko's "SQL Programming Style" is a good not vendor-specific book. And maybe a bit too Developer/User-ish but very good his "SQL for Smarties". Rod -- > > As for PostgreSQL-specific books, I can only speak for one I read > before: Bruce Momjian's "PostgreSQL: Introduction and Concepts". It is a > good introductionary book, although it isn't based on PostgreSQL 8 series. > > On 2/6/08, *Ron St-Pierre* <ron.pgsql@shaw.ca > <mailto:ron.pgsql@shaw.ca>> wrote: > > Unfortunately there isn't a current version of Joshua Drake's book out > there (which I do own along with PostgreSQL Essential Reference by > Stinson), so alternatively, can anyone recommend a good DBA book > outlining best practices, physical design, etc? I would like something > that is relevant to PostgreSQL even though it won't likely be PostgreSQL > specific. Based on current best practices I could then investigate which > tools postgres has available to implement them. > > Currently our small company has a single redhat server for the database > and web server, backups obviously are on a separate box. We want to add > hardware over the next few months and would like to/need to separate > functions and take advantage of things like: replication, PITR, > clustering, failover, plgpsql, material view perhaps, and likely more > which would be useful to speed up and protect our data. > > I want to increase my DBA and postgres skills prior to the upgrade, and > would like some direction from somewhere (book, group) on where to go > from here. Our current database is about 50G large and is a fairly > straightforward setup. I am the DBA and am also one of the developers, > and my practical DBA knowledge comes from setting up our database and > administering it. I make use of views and plpgsql, but from following > the lists realize that there are many more tools available in postgres > that could be used. > > Two possible references I found are: > - "Physical Database Design: the database professional's guide to > exploiting indexes, views, storage, and more" by S. Lightstone, T. > Teorey, T. Nadeau > http://www.amazon.com/Physical-Database-Design-professionals-exploiting/dp/0123693896 > - "Database Administration: The Complete Guide to Practices and > Procedures" by Craig S. Mullins > http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1202257162&sr=8-1 > <http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1202257162&sr=8-1> > Can anyone recommend these, or others? > > > Any and all suggestions welcome. > > Thanks > > Ron > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > > > -- > Sincerely yours, > Olexandr Melnyk <>< > http://omelnyk.net/
В списке pgsql-general по дате отправления:
Предыдущее
От: Ron St-PierreДата:
Сообщение: Re: DBA Book - Not "postgresql book - practical or something newer?"