The following features help in tuning the performance:
Monitoring event history
Postgres Enterprise Manager
Tuning Wizard