Re: Re[2]: [HACKERS] Fwd: Joins and links - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re[2]: [HACKERS] Fwd: Joins and links
Date
Msg-id 199907061504.LAA10481@candle.pha.pa.us
Whole thread Raw
In response to Re[2]: [HACKERS] Fwd: Joins and links  (Leon <leon@udmnet.ru>)
List pgsql-hackers
> When you will decide - to implement or not to implement,
> I urge you to think again about the relief on optimizer,
> which I stressed many times. No one rebutted yet that adding
> brains to optimizer so that it can use appropriate join method
> will require major rewrite. With links you get the best join
> method as side effect - virtually for free. These joins
> will never be too slow for an unknown reason. Think carefully.
> I hope you will make wise decision.

I believe Ingres does allow this, as it has tid's too.  If you are
creating a temp table, you could use tids during your processing.  In
fact, it seems tids would be valid until a vacuum is performed.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Leon
Date:
Subject: Re[2]: [HACKERS] Fwd: Joins and links
Next
From: Clark Evans
Date:
Subject: Re: [HACKERS] Fwd: Joins and links