Postgres Pro
Downloads
Home   >   mailing lists

Re: Large transaction problem - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Large transaction problem
Date
Msg-id 20041112143349.GA32479@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Large transaction problem  ("Paul B. Anderson" <paul@pnlassociates.com>)
Responses Re: Large transaction problem  ("Paul B. Anderson" <paul@pnlassociates.com>)
Consult is very slow  (Vida Luz <vlal@ideay.net.ni>)
List pgsql-admin
Tree view 
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.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-admin by date:

Previous
From: Francisco Jose Bernabe Pellicer
Date:
Subject: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
Next
From: "Paul B. Anderson"
Date:
Subject: Re: Large transaction problem