From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>

> If there is a transaction running when 'vacuumdb -a -z' is run (as a cron
> job) it stops running at that database till the transaction completes.
That
> is not so much of a problem until a new client tries to connect to the
> database.  This new connection hangs, waiting for the vacuum to complete.
> This situation is not all that helpful and means I have to be careful at
> what time I run vacuum so it does not interfere with new clients.  Is this
a
> bug or the standard way in which postgres works and are there any plans
> change this?

Would vacuuming the tables one at a time not help here? It'd mean a small
script to read a list of databases/tables out of PG but should reduce the
impact on your clients (if I'm thinking straight here)

- Richard Huxton

In response to

• Vacuum and Transactions at 2001-07-06 14:25:49 from Trewern, Ben

pgsql-hackers by date

Next:	From: Jean-Francois Leveque	Date: 2001-07-06 17:11:13
	Subject: Re: Database Users Management and Privileges
Previous:	From: J-P Guguy	Date: 2001-07-06 16:16:47
	Subject: amiint

pgsql-general by date

Next:	From: Ed Loehr	Date: 2001-07-06 16:59:22
	Subject: query syntax change?
Previous:	From: Steve Wampler	Date: 2001-07-06 16:29:57
	Subject: Too much data received?