Re: [HACKERS] Fwd: Joins and links

Поиск
Список
Период
Сортировка
От Leon
Тема Re: [HACKERS] Fwd: Joins and links
Дата
Msg-id 37849684.1AD88635@udmnet.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] Fwd: Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Fwd: Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Leon
Дата:
Сообщение: Re: [HACKERS] Fwd: Joins and links
Следующее
От: Peter Mount
Дата:
Сообщение: RE: [HACKERS] Updated TODO list