Re: Use unique index for longer pathkeys. - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: Use unique index for longer pathkeys.
Date
Msg-id 20140707122339.GA13469@toroid.org
Whole thread Raw
In response to Use unique index for longer pathkeys.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: Use unique index for longer pathkeys.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
Hi.

I took a quick look at this patch, more or less because nobody else did.

> Duing last CF, I proposed to match long pathkeys against index columns
> during creating index paths. This worked fine but also it is difficult
> to make sure that all side-effects are eliminated. Finally Tom Lane
> suggested to truncate pathkeys while generation of the pathkeys
> itself. So this patch comes.

I found your older patch quite straightforward to understand, but the
new one much more difficult to follow (but that's not saying much, I
am not very familiar with the planner code in general).

Do you have any references to the discussion about the side-effects that
needed to be eliminated with the earlier patch?

-- Abhijit



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: "RETURNING PRIMARY KEY" syntax extension
Next
From: Robert Haas
Date:
Subject: Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]