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

Re: Large transaction problem

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large transaction problem
Date: 2004-11-12 14:33:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Thu, Nov 11, 2004 at 05:14:50PM -0500, Paul B. Anderson wrote:
>  /usr/bin/vacuumdb --all --full --analyze

You do realise that takes an exclusive lock, right?  Why are you
doing VACUUM FULL?  If your FSM is set right, you really shouldn't
need it for most cases.


Andrew Sullivan  | ajs(at)crankycanuck(dot)ca
The plural of anecdote is not data.
		--Roger Brinner

In response to


pgsql-admin by date

Next:From: Paul B. AndersonDate: 2004-11-12 15:30:27
Subject: Re: Large transaction problem
Previous:From: Francisco Jose Bernabe PellicerDate: 2004-11-12 14:14:33
Subject: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'

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