Re: Very long time to commit or close connections

Oops, meant to copy the list on this...

----- Original Message -----
From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Monday, January 19, 2004 8:01 AM
Subject: Re: [GENERAL] Very long time to commit or close connections

> > There are not that many things happening during connection close. Does
> > your app use temp tables? LISTEN/NOTIFY?
>
> Nope. It's actually a very simple application. It uses plain select,
insert,
> update, and delete statements with nothing particularly unusual beyond that.
>
> > Nope ... how about looking at the contents of the pg_locks system view
> > when this happens? What external conditions correspond to the instant
> > when the hangs are released? (I do not believe that it just happens by
> > magic --- look for background cron jobs starting or finishing at that
> > time, eg a cron job that issues VACUUMs.)
>
> Hmm... I will definitely look. I pretty much know that it's not a vacuum.
I
> suppose I could have our system monitor insert information from the 'ps'
> utility when there are outstanding connections.
>
> > What PG version is this, anyway?
>
> 7.3.2. We could upgrade within the 7.3 series, but have not qualified the
> application on 7.4 at this point. (there are complications, mostly because
of
> a patch we apply to the JDBC drivers, which change for 7.4).
>
> --
> www.designacourse.com
> The Easiest Way to Train Anyone... Anywhere.
>
> Chris Smith - Lead Software Developer/Technical Trainer
> MindIQ Corporation
>