postgresql

http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL

http://www.sitepoint.com/site-mysql-postgresql-1/

hibernate profiler

http://hibernateprofiler.com/Learn

java agent instrumentation using javaassit

http://www.informit.com/guides/content.aspx?g=java&seqNum=589

to trace code using JavaAsssist

http://www.informit.com/guides/content.aspx?g=java&seqNum=585

hibernate debugging

show_sql,
format_sql
use log4j.properties, org.hibernate-> DEBUG, org.hibernate.type->FINE or use P6Spy to snoop JDBC connection

# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
 
# Root logger option
log4j.rootLogger=INFO, stdout
 
# Hibernate logging options (INFO only shows startup messages)
log4j.logger.org.hibernate=INFO
 
# Log JDBC bind parameter runtime arguments
log4j.logger.org.hibernate.type=trace

http://www.mkyong.com/hibernate/how-to-display-hibernate-sql-parameter-values-log4j/

http://www.mkyong.com/hibernate/how-to-configure-log4j-in-hibernate-project/ 

perm space

http://anshuiitk.blogspot.com/2010/11/excessive-full-garbage-collection.html