Thread: Simultaneous vacuum-ing
Is there any danger with simultaneous vacuum-ing with 7.2.3 ? Thanks
On Fri, Oct 25, 2002 at 03:33:48PM -0700, Medi Montaseri wrote:
> Is there any danger with simultaneous vacuum-ing with 7.2.3 ?
Simultaneous how? Same table, or different tables at the same time?
The latter works without trouble, I can assure you.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
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" Thanks Andrew Sullivan wrote: >On Fri, Oct 25, 2002 at 03:33:48PM -0700, Medi Montaseri wrote: > > >>Is there any danger with simultaneous vacuum-ing with 7.2.3 ? >> >> > >Simultaneous how? Same table, or different tables at the same time? >The latter works without trouble, I can assure you. > >A > > >
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