From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
---|---|
To: | John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> |
Cc: | Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: Avoid creation of the free space map for small tables |
Date: | 2019-03-13 02:52:07 |
Message-ID: | CAA4eK1LuO+MSRSsOvUMUOmY114kBRaK_1S+tqqHEODHjdV2k8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Mar 10, 2019 at 7:47 PM John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> wrote:
>
> On Fri, Mar 8, 2019 at 7:43 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kuroda, Hayato | 2019-03-13 02:52:19 | RE: ECPG regression with DECLARE STATEMENT support |
Previous Message | Paul Guo | 2019-03-13 02:39:11 | Re: Batch insert in CTAS/MatView code |