Original link: 9 High-Performance Tips when using PostgreSQL with JPA and Hibernate / Vlad Mihalcea blog.
I think most of it is relevant with any database access technology not just JPA.