RE: Parallel INSERT SELECT take 2
От | houzj.fnst@fujitsu.com |
---|---|
Тема | RE: Parallel INSERT SELECT take 2 |
Дата | |
Msg-id | OS0PR01MB5716DB16ED9AC78873D6C96294509@OS0PR01MB5716.jpnprd01.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: Parallel INSERT SELECT take 2 (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>) |
Список | pgsql-hackers |
> > > > > 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 по дате отправления: