-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Franck,
On 4/18/14, 5:05 AM, Franck Routier wrote: > we recently switched to tomcat-jdbc-pool as our connection pool, > and have since encountered performance problems with Postgresql. > The problem is due to the fact that postgres is having hard time > vacuuming, due to always ongoing idle transactions. See > http://permalink.gmane.org/gmane.comp.db.postgresql.performance/37893 > > for the details. > > It turns out that those idle transactions were coming from tomcat > pool validation queries... here is our configuration: > > <property name="defaultAutoCommit" value="false"/> <property > name="maxActive" value="30"/> <property name="maxIdle" > value="30"/> <property name="initialSize" value="10"/> <property > name="minIdle" value="10"/> <property name="testOnReturn" > value="true"/> <property name="testOnBorrow" value="true"/> > <property name="validationQuery" value="select 1 from rtelre"/> > <property name="validationInterval" value="0"/> > > rtelre is a dummy table with 1 column and one row. We use it for > compatibility reasons, since we deploy in several environments, and > on oracle the from clause is mandatory (so select 1 does not fit). Every database I've ever used accepts "SELECT 1 FROM DUAL" because Oracle did it first. You could try that. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJTUXKgAAoJEBzwKT+lPKRYs7oQAIo212h6oQgQ4tlTLWnWt/AJ Oc9kD0uCSZrsDZaABHkILPOGyqcKv+2uYHJ0+tMvuZw0rsYybVCSsxn3a/Kmqaqj wlm+md0ru0MA9/lbMwIPe1w8k8ppMk/fALBBooBu6M0RXs1oGnzAGfPoQ+RNA0Iu JeSOWKKRybQvHH+dv8dlJZJLPBCUx5KzLpuPtl3btDXt7Oa3X5qt+T8ya8W/yi8j QN171iNNZMANFAv32KTPIwIwvg5gup3ptFcHsqcY8prTee1qW25dShMAad4QEKRl eQqMhaI1ETzQaXofNt4WgCP32XPKpfqY0TEBpBBB+3VMLYm9hhEgM359FYZPonAJ EXTo7oGth/8HpO7ZwL7OGV73gf4iondPjPiG8+ks9OI4aWhBN717OLQGwkn5JbaP DYFQJiQ57zcWKcWWUhk6BC4Rh1K61Z69V/D5V2iAtjClvJNGgdIBsyG1DEGD1u+z RkoR3LIQi+n6qPld+XzWqP2nNc5YckbCSR6bL0pza/sraGJXymCwXdbJtlVL3sJT YGF10pfApEt4Imoi6+WjiLX8G3bd0/FNfp02rxJtsQL+eyDXUUICz8dOoJhBkIp2 vgr/u8TM0O+vu/pt4v/aovJO1Rqggsr76Rp5xUqY0Amzrn1wg7b9f8uDr8EhZNFv d3R4rDxto3/8b9upDJUz =p05t -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
