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

From Leon
Subject Re: [HACKERS] Fwd: Joins and links
Date
Msg-id 37849684.1AD88635@udmnet.ru
Whole thread Raw
In response to Re: [HACKERS] Fwd: Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Fwd: Joins and links
List pgsql-hackers
Bruce Momjian wrote:

> > As somone who has developed several commercial dbms systems,
> > I would discourage doing a special "link" type.  There are
> > other ways to gain performance -- de-normalize your tables
> > if you are doing mainly reads; carefully check your storage
> > layout; and, of course, buy more RAM ;-)
> 
> Good to see you around Bob.  This guy does know what he is talking
> about.
> 

After thinking a bit, it became clear to me that we are flaming 
senselessly here. So can anyone do a fast hack to test links
for speed? Especially with three or more tables being joined.

-- 
Leon.




pgsql-hackers by date:

Previous
From: Leon
Date:
Subject: Re: [HACKERS] Fwd: Joins and links
Next
From: Peter Mount
Date:
Subject: RE: [HACKERS] Updated TODO list