Re: What's a good PostgreSQL guide book?

Martha Stewart called it a Good Thing when"Gary Hendricks" <ghendricks(at)yahoo(dot)com>wrote:
> I'm thinking of buying "Practical PostgreSQL"
> from O'Reilly.
>
> Has anyone got any comments on this book? Can anyone suggest
> alternatives?
>
> My level is best described as "intermediate".
> Thanks in advance!

The main problem with it is that it is somewhat out of date, being
(roughly) descriptive of 7.1, when we're now at 7.3, where there are
fairly significant improvements that the book certainly does not
address.

There's a new book from New Riders that I browsed on the weekend that
seems quite good in discussing architecture; it is definitely better
in its discussion of vacuuming and performance tuning.

The thing that's "wrong" with any of the books that are available is
that they have considerable portions about the whole variety of
language "bindings" (e.g. - Perl, Python, C, C++, ...) which bulk up
the book when it's really only likely that you'd need a reference on
one or two of the languages.

I would have loved to see twice or three times as much in the NR book
on performance tuning, and at least twice as much discussion about the
implications of MVCC.

The ORA book isn't useless; I keep a copy on my desk, and fairly
regularly look at it. Mind you, I more often use the copy of the PG
docs that I put on my PalmPilot that represents the /same material/,
only three versions newer.

If ORA does a new edition (and it's probably not the ideal time for
it, with the book market being rather soft), it would be a pretty good
choice; otherwise, I'd suggest that the NR book has more modern
material that would encourage buying it.
--
output = reverse("gro.mca@" "enworbbc")
http://cbbrowne.com/info/sgml.html
Rules of the Evil Overlord #45. "I will make sure I have a clear
understanding of who is responsible for what in my organization. For
example, if my general screws up I will not draw my weapon, point it
at him, say "And here is the price for failure," then suddenly turn
and kill some random underling." <http://www.eviloverlord.com/>