Re: WIP Join Removal

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, List pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: WIP Join Removal
Date: 2008-09-02 11:53:50
Message-ID: 1220356430.4371.382.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

On Tue, 2008-09-02 at 12:05 +0100, Gregory Stark wrote:

> I wonder if it would be more worthwhile to remove them and have a
> subsequent phase where we look for possible joins to *add*. So even if
> the user writes
> "select * from invoices where customer_id=?" the planner might be able
> to discover that it can find those records quicker by scanning
> customer, finding the matching <company_id,customer_id> and then using
> an index to look them up in invoices.

That's a good idea.

Simon Riggs
PostgreSQL Training, Services and Support

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2008-09-02 11:59:37 Re: TODO item: Implement Boyer-Moore searching (First time hacker)
Previous Message Simon Riggs 2008-09-02 11:38:18 Re: WIP Join Removal