Re: WIP: Avoid creation of the free space map for small tables
От | Amit Kapila |
---|---|
Тема | Re: WIP: Avoid creation of the free space map for small tables |
Дата | |
Msg-id | CAA4eK1LuO+MSRSsOvUMUOmY114kBRaK_1S+tqqHEODHjdV2k8Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: WIP: Avoid creation of the free space map for small tables (John Naylor <john.naylor@2ndquadrant.com>) |
Список | pgsql-hackers |
On Sun, Mar 10, 2019 at 7:47 PM John Naylor <john.naylor@2ndquadrant.com> wrote: > > On Fri, Mar 8, 2019 at 7:43 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > Have you done any performance testing of this patch? I mean to say > > now that we added a new stat call for each table, we should see if > > that has any impact. Ideally, that should be compensated by the fact > > that we are now not transferring *fsm files for small relations. How > > about constructing a test where all relations are greater than 4 pages > > and then try to upgrade them. We can check for a cluster with a > > different number of relations say 10K, 20K, 50K, 100K. > > I have not, but I agree it should be done. I will try to do so soon. > Thanks, I will wait for your test results. I believe this is the last patch in this project and we should try to get it done soon. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: