RE: Parallel INSERT SELECT take 2

Поиск
Список
Период
Сортировка
Искать
От
houzj.fnst@fujitsu.com
Тема
RE: Parallel INSERT SELECT take 2
Дата
в 08:24:43
Msg-id
OS0PR01MB5716DB16ED9AC78873D6C96294509@OS0PR01MB5716.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
Parallel INSERT SELECT take 2 "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel INSERT SELECT take 2 Dilip Kumar <dilipbalaut@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
Re: Parallel INSERT SELECT take 2 Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Greg Nancarrow <gregn4422@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Parallel INSERT SELECT take 2 Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: Parallel INSERT SELECT take 2 "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
> > > > > So, users need to check count(*) for this to determine
> > > > > parallel-safety? How about if we provide a wrapper function on
> > > > > top of this function or a separate function that returns char to
> > > > > indicate whether it is safe, unsafe, or restricted to perform a
> > > > > DML operation on the table?
> > > >
> > > > Such wrapper function make sense.
> > >
> > > Thanks for the suggestion, and I agree.
> > > I will add another wrapper function and post new version patches soon.
> >
> > Attaching new version patches with the following changes:
> >
> > 0001
> > Add a new function pg_get_max_parallel_hazard('table_name') returns
> > char('s', 'u', 'r') which indicate whether it is safe, unsafe, or restricted to
> perform a DML.
> 
> Thanks for the patches. I think we should have the table name as regclass type
> for pg_get_max_parallel_hazard? See, pg_relation_size, pg_table_size,
> pg_filenode_relation and so on.

Thanks for the comment.
I have changed the type to regclass in the latest patchset.

Best regards,
houzj
В списке pgsql-hackers по дате отправления
От: houzj.fnst@fujitsu.com
Дата:
От: Pavel Borisov
Дата:
Сообщение: Re: OOM in spgist insert
FAQ