Re: Simultaneous vacuum-ing

Поиск
Список
Период
Сортировка
Искать

Re: Simultaneous vacuum-ing

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
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
                              M2P 2A8
                                         +1 416 646 3304 x110

Re: Simultaneous vacuum-ing

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
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
                              M2P 2A8
                                         +1 416 646 3304 x110

Simultaneous vacuum-ing

От:
Medi Montaseri <medi.montaseri@intransa.com>
Дата:
Is there any danger with simultaneous vacuum-ing with 7.2.3 ?

Thanks

Re: Simultaneous vacuum-ing

От:
Medi Montaseri <medi.montaseri@intransa.com>
Дата:
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
>
>  
>
FAQ