Re: parallel vacuum comments

Поиск
Список
Период
Сортировка
Искать
От
Masahiko Sawada
Тема
Re: parallel vacuum comments
Дата
Msg-id
CAD21AoDjr-NP7GuWr9vw3jz9+C4a8xa67d81JSGtf=eqHL-S5w@mail.gmail.com
Ответ на
Список
Дерево обсуждения
parallel vacuum comments Andres Freund <andres@anarazel.de>
Re: parallel vacuum comments Andres Freund <andres@anarazel.de>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Andres Freund <andres@anarazel.de>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Peter Geoghegan <pg@bowt.ie>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Peter Geoghegan <pg@bowt.ie>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Amit Kapila <amit.kapila16@gmail.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Peter Geoghegan <pg@bowt.ie>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Peter Geoghegan <pg@bowt.ie>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
RE: parallel vacuum comments "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
Re: parallel vacuum comments Peter Geoghegan <pg@bowt.ie>
Re: parallel vacuum comments Masahiko Sawada <sawada.mshk@gmail.com>
 and

On Fri, Dec 3, 2021 at 6:56 PM Amit Kapila  wrote:
>
> On Fri, Dec 3, 2021 at 2:33 PM Amit Kapila  wrote:
> >
> > On Thu, Dec 2, 2021 at 6:01 PM Masahiko Sawada  wrote:
> > >
> > > I've attached updated patches.
> > >
> >
> > I have a few comments on v4-0001.
> >
>
> The new test proposed by v4-0003 is increasing the vacuum_parallel.sql
> timing by more than 10 times. It appears to be taking the highest time
> among all the tests in make check. I think it is because of a large
> amount of data being processed by the test.

Right.

> I think it is good to use
> it for testing of patches during development but won't be a good idea
> to commit. Can we reduce its timings?

On reflection, we already have test cases for:

* a parallel vacuum does bulkdeletion and cleanup
* a parallel vacuum does only cleanup

and the case that the new tests add is that a vacuum does bulkdeletion
twice and cleanup. Given the increasing the regression test time, the
thrid patch might not worth to be added.


Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/


В списке pgsql-hackers по дате отправления
От: Dilip Kumar
Дата:
От: Amit Langote
Дата:
FAQ