Postgres is a database with a lot of features. Chrunchydata has provided tutorials for advanced features.
Here you can find:
- information about PostGIS (database storage for geography data)
- all about window functions
- partitioning of data
- indexes and how to use them