[ADMIN] COMMIT takes long time for read only transaction

Hi, all. Postgres 8.4.4, quite often I have situation like this: 011-05-26 18:25:38.842 CEST [16163] [192.168.1.5(32431)] SET LOG: duration: 0.029 ms statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED 2011-05-26 18:25:38.843 CEST [16163] [192.168.1.5(32431)] SELECT LOG: dur

Re: [ADMIN] COMMIT takes long time for read only transaction

Mario Splivalo wrote: > 2011-05-26 18:25:51.624 CEST [16163] > [192.168.1.5(32431)] > COMMIT LOG: duration: 11159.202 ms statement: COMMIT > 2011-05-26 18:26:05.788 CEST [16163] > [192.168.1.5(32431)] > COMMIT LOG: duration: 326.856 ms statement: COMMIT > > This is a grep from a postgre