Fuzzy.cz

About a month ago I've bought this book from Greg Smith, and I'm excited with it. It's quite exhaustive collection of information related to "database performance tuning" - note I haven't mentioned PostgreSQL on purpose, as at least a third of the book is about general topics you have to face with every database (hardware limits, filesystems and their advantages/disadvantages, monitoring server using vmstat/iostat/... and identification of typical problems etc.). And besides that there is obviously huge amount of information specific to PostgreSQL ...

In PostgreSQL there are two different ways to perform partitioning - using rules and using triggers.  One of the usual reasons why a partitioningu is used, is a performance, so lets analyze differences between these two ways regarding performance.