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.
> 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
> 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
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|
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?|