Re: about index inheritance

On Tue, May 7, 2013 at 11:55 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, May 6, 2013 at 9:30 AM, Vincenzo Melandri <vmelandri(at)imolinfo(dot)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