Horton
Menu

Thread

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Remove unused function parameter in get_qual_from_partbound

  2. Fix cardinality estimates for parallel joins.

  1. Unused function parameter in get_qual_from_partbound()

    Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com> — 2021-06-08T09:50:28Z

    Hi,

I noticed that the first function parameter in get_qual_from_partbound(**Relation rel**, Relation parent,
is not used in the function.

Is it better to remove it like the attached patch ?

Best regards,
houzj

  2. Re: Unused function parameter in get_qual_from_partbound()

    David Rowley <dgrowleyml@gmail.com> — 2021-06-08T11:30:05Z

    On Tue, 8 Jun 2021 at 21:50, houzj.fnst@fujitsu.com
<houzj.fnst@fujitsu.com> wrote:
> I noticed that the first function parameter in get_qual_from_partbound(**Relation rel**, Relation parent,
> is not used in the function.
>
> Is it better to remove it like the attached patch ?

Going by [1] it was used when it went in. It looks like it was for
mapping attribute numbers between parent and partition rels.

Going by [2], it looks like it became unused due to the attribute
mapping code being moved down into map_partition_varattnos().

As for whether we should remove it or not, because it's an external
function that an extension might want to use, it would need to wait
until at least we branch for PG15.

Likely it's best to add the patch to the July commitfest so that we
can make a decision then.

David

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/catalog/partition.c;h=6dab45f0edf8b1617d7239652fe36f113d30fd7a;hb=f0e44751d71
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blobdiff;f=src/backend/catalog/partition.c;h=874e69d8d62e8e93164093e7352756ebfd0f69bc;hp=f54e1bdf3fb52cefed9b0d2fe7ab2a169231579d;hb=0563a3a8b5;hpb=0c2070cefa0e5d097b715c9a3b9b5499470019aa

  3. RE: Unused function parameter in get_qual_from_partbound()

    Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com> — 2021-06-09T00:28:48Z

    On Tuesday, June 8, 2021 7:30 PM David Rowley <dgrowleyml@gmail.com>
> On Tue, 8 Jun 2021 at 21:50, houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com>
> wrote:
> > I noticed that the first function parameter in
> > get_qual_from_partbound(**Relation rel**, Relation parent, is not used in the
> function.
> >
> > Is it better to remove it like the attached patch ?
> 
> Going by [1] it was used when it went in. It looks like it was for mapping attribute
> numbers between parent and partition rels.
> 
> Going by [2], it looks like it became unused due to the attribute mapping code
> being moved down into map_partition_varattnos().
> 
> As for whether we should remove it or not, because it's an external function
> that an extension might want to use, it would need to wait until at least we
> branch for PG15.
> 
> Likely it's best to add the patch to the July commitfest so that we can make a
> decision then.

OK, Thanks for the explanation.
Added to CF: https://commitfest.postgresql.org/33/3159/

Best regards,
houzj

  4. Re: Unused function parameter in get_qual_from_partbound()

    Michael Paquier <michael@paquier.xyz> — 2021-06-09T02:50:10Z

    On Wed, Jun 09, 2021 at 12:28:48AM +0000, houzj.fnst@fujitsu.com wrote:
> OK, Thanks for the explanation.
> Added to CF: https://commitfest.postgresql.org/33/3159/

At first glance, this looked to me like breaking something just for
sake of breaking it, but removing the rel argument could be helpful
to simplify any external code calling it as there would be no need for
this extra Relation.  So that looks like a good idea, no need to rush
that into 14 though.
--
Michael

  5. Re: Unused function parameter in get_qual_from_partbound()

    Soumyadeep Chakraborty <soumyadeep2007@gmail.com> — 2021-07-10T22:44:23Z

    Hello,

Googling around, I didn't find any extensions that would break from this
change. Even if there are any, this change will simplify the relevant
callsites. It also aligns the interface nicely with get_qual_for_hash,
get_qual_for_list and get_qual_for_range.

Marking this as ready for committer. It can be committed when the branch
is cut for 15.

Regards,
Soumyadeep (VMware)

  6. Re: Unused function parameter in get_qual_from_partbound()

    Soumyadeep Chakraborty <soumyadeep2007@gmail.com> — 2021-07-10T22:57:43Z

    > Marking this as ready for committer. It can be committed when the branch
> is cut for 15.

I see that REL_14_STABLE is already cut. So this can go in now.

  7. Re: Unused function parameter in get_qual_from_partbound()

    John Naylor <john.naylor@enterprisedb.com> — 2021-07-12T12:46:05Z

    On Tue, Jun 8, 2021 at 10:50 PM Michael Paquier <michael@paquier.xyz> wrote:
>
> At first glance, this looked to me like breaking something just for
> sake of breaking it, but removing the rel argument could be helpful
> to simplify any external code calling it as there would be no need for
> this extra Relation.  So that looks like a good idea, no need to rush
> that into 14 though.

I found no external references in codesearch.debian.net. I plan to commit
this in the next couple of days unless there are objections.

--
John Naylor
EDB: http://www.enterprisedb.com

  8. Re: Unused function parameter in get_qual_from_partbound()

    John Naylor <john.naylor@enterprisedb.com> — 2021-07-14T14:06:02Z

    On Mon, Jul 12, 2021 at 8:46 AM John Naylor <john.naylor@enterprisedb.com>
wrote:
>
> On Tue, Jun 8, 2021 at 10:50 PM Michael Paquier <michael@paquier.xyz>
wrote:
> >
> > At first glance, this looked to me like breaking something just for
> > sake of breaking it, but removing the rel argument could be helpful
> > to simplify any external code calling it as there would be no need for
> > this extra Relation.  So that looks like a good idea, no need to rush
> > that into 14 though.
>
> I found no external references in codesearch.debian.net. I plan to commit
this in the next couple of days unless there are objections.

This has been committed.

--
John Naylor
EDB: http://www.enterprisedb.com