Postgres Pro
Downloads
Home   >   mailing lists

Re: Simultaneous vacuum-ing - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Simultaneous vacuum-ing
Date
Msg-id 20021028173541.N21128@mail.libertyrms.com
Whole thread Raw
In response to Re: Simultaneous vacuum-ing  (Medi Montaseri <medi.montaseri@intransa.com>)
List pgsql-general
Tree view 
On Mon, Oct 28, 2002 at 11:25:53AM -0800, Medi Montaseri wrote:
> Simultaneous as in, running vacuumdb(1) simultaneously or sequentially..
> For example,
>
> vacuumdb -z -d SomeDB &
> vacuumdb -z -d SomeDB &
> psql -c "some SQL statement, where I'm in a 7.2.3 and supposedly, I can
> do vacuum and
> DB transactions at the same time"

This I haven't tested.  I would anticipate performance trouble,
though.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: command-line history (readline) fails
Next
From: Medi Montaseri
Date:
Subject: Re: Two Phase Commit support