Postgres Pro
Downloads
Home   >   mailing lists

Re: Hangs with 7.1.2 and vacuum - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: Hangs with 7.1.2 and vacuum
Date
Msg-id 3B5BE67F.17E99B5D@tpf.co.jp
Whole thread Raw
In response to Hangs with 7.1.2 and vacuum  (Stephen Robert Norris <srn@commsecure.com.au>)
Responses Re: Hangs with 7.1.2 and vacuum  (Stephen Robert Norris <srn@commsecure.com.au>)
List pgsql-general
Tree view 
Stephen Robert Norris wrote:
>
> Has anyone else noticed hangs with 7.1.2 and the vacuum statement?
>
> I often get this happening when the vacuum starts and there are other
> queries going on. Closing the other connections seems to fix it,
> although they all claim to be idle.
>

Are those idle connections out of transactions ?

regards,
Hiroshi Inoue

pgsql-general by date:

Previous
From: Mark kirkwood
Date:
Subject: Re: How Postgresql.... Putting Count(*) To Bed (Hopefully)
Next
From: Stephen Robert Norris
Date:
Subject: Re: Hangs with 7.1.2 and vacuum