Re: WIP: Avoid creation of the free space map for small tables

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

In response to

Browse pgsql-hackers by date

  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