Skip site navigation (1) Skip section navigation (2)

Vacuum and Transactions

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum and Transactions
Date: 2001-07-06 14:25:49
Message-ID: 996802F75C3CD411B424001083FA445B059580@CET_PONXX_FP001 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Hi all,

I am having the following problems using Postgres 7.1.2 with clients which
have long transactions:

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?

Regards

Ben


*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************

Responses

pgsql-hackers by date

Next:From: Gunnar RønningDate: 2001-07-06 15:08:05
Subject: Re: Database Users Management and Privileges
Previous:From: Tom LaneDate: 2001-07-06 14:20:48
Subject: Re: AW: AW: Re: Backup and Recovery

pgsql-general by date

Next:From: Mithun BhattacharyaDate: 2001-07-06 14:25:52
Subject: Another DBD::Pg question
Previous:From: Mithun BhattacharyaDate: 2001-07-06 14:23:57
Subject: Newbie DBD::Pg question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group