I just posted a bit long article about how awesome PostgreSQL is ;). Check out it for some basics, but also for tips on sharding, partitioning, replicating, data types and quite a few helpful links.