Re: [HACKERS] Fwd: Joins and links

From: Leon <leon(at)udmnet(dot)ru>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: Bob Devine <devine(at)cs(dot)utah(dot)edu>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Fwd: Joins and links
Date: 1999-07-08 12:16:04
Message-ID: 37849684.1AD88635@udmnet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Leon 1999-07-08 12:19:33 Re: [HACKERS] Fwd: Joins and links
Previous Message Vadim Mikheev 1999-07-08 11:45:47 Re: [HACKERS] Delaying insertion of default values