FM wrote: > What is strange is that users on all DB (not only DB1) are affected > by the JBOSS <idle in transaction>. > I understand that it locked DB1 but why it also locked users on > others DB ?
This is fairly impossible. Please show us more concrete evidence of what you are observing. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings