Re: Large transaction problem

From: "Paul B(dot) Anderson" <paul(at)pnlassociates(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large transaction problem
Date: 2004-11-12 15:30:27
Message-ID: 4194D713.3000402@pnlassociates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When the vacuum full timed out, could the exclusive lock have been left
set, leaving the database in an unusable state?

BTW, thanks. I removed the --full option.

Paul

Andrew Sullivan wrote:

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2004-11-12 15:57:28 Re: Large transaction problem
Previous Message Andrew Sullivan 2004-11-12 14:33:49 Re: Large transaction problem