| From: | Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Hangs with 7.1.2 and vacuum |
| Date: | 2001-07-23 08:59:55 |
| Message-ID: | 20010723185955.A1005@sunhill.commsecure.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 23, 2001 at 05:55:27PM +0900, Hiroshi Inoue wrote:
> 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
Well spotted - I just worked that out :) We are using python, and we've
locally modified the pgdb.py module to not open a transaction; sadly the
person installing one of the client machines missed that step...
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | roy_ | 2001-07-23 09:40:42 | Field name |
| Previous Message | Hiroshi Inoue | 2001-07-23 08:55:27 | Re: Hangs with 7.1.2 and vacuum |