Updates

Latest Tweet



What's New?

Check out for latest innovation, a computer based training video collection


Like this Page

Practical PostgreSQL (O'Reilly Unix) Review by P. Hoogendijk

Nice for PostgreSQL intro, but not a master piece

The book covers the basics of PostgreSQL, but it lacks usefull info for the more avanced tasks like tuning the database.
The 'stored procedure' (PL/pgSQL) chapter was for me the only interesting part of this book for me.
When I bought this I was hoping for the PostgreSQL 'Bible', but it was a big dissapointment.

My advice for improvement for the next release:
- much better index
- drop LXP chapter
- chapter about how to tune (not just SQL statements, but the postgreSQL server itself) and benchmark PostgreSQL.
- a chapter about 'schema' and when to use them.
- extend PL/pgSQL chapter with some 'real world' examples and how to do PL/pgSQL trouble shooting, PL/Perl(?)

- general advice how to manage PostgreSQL on 'day to day' basis
- maybe have a chapter about the SLONY replication add-on
- Postgresql 8.0 features