Re: about index inheritance - Mailing list pgsql-hackers

From Vincenzo Melandri
Subject Re: about index inheritance
Date
Msg-id CAHSd9GfxAKK7+3CnWVKa5C_iKL6rPhRKAo+NvQjPA_1sFRKSmQ@mail.gmail.com
Whole thread Raw
In response to Re: about index inheritance  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: about index inheritance  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
On Tue, May 7, 2013 at 11:55 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Mon, May 6, 2013 at 9:30 AM, Vincenzo Melandri <vmelandri@imolinfo.it> wrote:
> Hi guys,
>
> My first post here :)
> I stumbled into the same problem as this guy
> http://www.postgresql.org/message-id/4BE2835A.5020601@cybertec.at
> , so since I have some spare time recently, I've set-up the development
> environment for postgresql and I think I may be able to contibute for the
> feature of index inheritance, that is currently unsopported, but listed in
> TODOs.
>
> I've spent some time reading the docs and I took a look at the code. Is
> anybody out there working on this already? I don't want to overlap someone
> else effort, plus I'll gladly take any advice or join the community efforts
> if any, 'cause this feature seems pretty huge to me at a first glance..

This is a really hard problem.  If you pick this as your first project
hacking on PostgreSQL, you will almost certainly fail.


Thank you very much, i guessed that already -.-
Still, I needed that at my office for a long time, struggled with it many times and had to come out with some "exotic" solutions...
Now I have spare time between projects, so I can work on it full-time. At least it's worth a try, isn't it?

Anyway, I'm working to better understand the problem, trying to identify at least the main involved points.
At the moment I'm figuring out how the inherit mechanism works for relations (in tablecmds.c).. Then I'll figure out about how indexes work..

I guess you discussed this plenty of time already in the past, but I didn't found it in the archive. Any hint for old discussions? 
I'll try to come out with a list of potential things to do, for you guys to validate and discuss.

PS: i wrote last mail from an address with which I had not subscribed to the list, and still the message got through.. Odd..
--
Vincenzo.
http://www.linkedin.com/pub/vincenzo-melandri/14/16/730

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Add some regression tests for SEQUENCE
Next
From: Heikki Linnakangas
Date:
Subject: Re: GSOC Student Project Idea