Обсуждение: 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