Re: pgbench - allow to create partitioned tables
От | Amit Kapila |
---|---|
Тема | Re: pgbench - allow to create partitioned tables |
Дата | |
Msg-id | CAA4eK1JoTewRuV-9dOHb7jX8O9Nw2dpwsX+pFeTCdf=JmfY4wg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: pgbench - allow to create partitioned tables (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Ответы |
Re: pgbench - allow to create partitioned tables
|
Список | pgsql-hackers |
On Fri, Sep 27, 2019 at 7:05 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > > On 2019-Sep-27, Amit Kapila wrote: > > > The other thing is that the query used in patch to fetch partition > > information seems correct to me, but maybe there is a better way to > > get that information. > > I hadn't looked at that, but yeah it seems that it should be using > pg_partition_tree(). > I think we might also need to use pg_get_partkeydef along with pg_partition_tree to fetch the partition method information. However, I think to find reloid of pgbench_accounts in the current search path, we might need to use some part of query constructed by Fabien. Fabien, what do you think about Alvaro's suggestion? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: