As a sidequestion, what's a good ressource for getting into the postgres world?
The introduction tutorial is concise but more than sufficient.
The reference guide is well written, laid-out and covers everything you need: the database server, its configuration and tools, the SQL language, its operators, data types and grammar, the built-in procedural languages, the low-level client library, and all the database internals (system tables, data file formats, network protocol, query optimiser, indexes, etc).
The mailing lists also seem to carry a lot of good material.