thanks for the reply. how do I kill these idle sessions? And if I do, will it cause any issues? ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/Why-are-a-lot-of-ROLLBACK-queries-in-idle-state-tp5930917p5931144.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin