I've come across a couple of books on PG that appear interesting and was
wondering if others have read them and what their thoughts are. (Excuse
me if this topic has already been covered previously)
Practical PostgreSQL - Command Prompt
PostgreSQL - Bruce Momjian
I know Bruce and the CP folks are regular posters here and I am
certainly aware of their in depth knowledge on PG so as far as knowing
that the books would be reliable in the information they give I have no
problems there.
At the moment my usage of PG is fairly basic, a bunch of tables that
contains a replication of data in our primary application which is
loaded by a single application and used by our customers with MS Access,
Crystal Reports and other tools to generate reports. I.e. in effect to
our customers it's a read only database and any data being put in has
already been subjected to constraint testing etc by the primary (non PG)
database so I haven't set up any foreign keys, triggers/functions,
views, sequences etc. Really the only thing in use is basic data in
tables with some indexes to make reports quicker.
I want to start expanding the usage and getting into the guts of proper
performance tuning (right now all PG installations are using the default
parameters - the only thing that has been changed is the pg_hba file to
allow access) and these books look like they might be worth reading to
understand a bit more about how all this works.
Can anyone who has read the books let me know if you have found them to
be valuable reference tools for someone who is relatively novice at PG
(but not at databases in general) - Note: Praise from the books authors
will be considered marginally bias and therefore untrustworthy :)
I know, I could have written a two line email asking this question, but
sometimes I like to go on and on and on and on.
Thanks for your input though.
--
Paul Lambert
Database Administrator
AutoLedgers