Re: Query optimizing - paradox behave

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Query optimizing - paradox behave
Дата
Msg-id Pine.BSF.4.21.0107190810000.35685-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Query optimizing - paradox behave  ("David M. Richter" <D.Richter@DKFZ-heidelberg.de>)
Список pgsql-sql
What version are you using? (dbPG95GetIndex?)

On Thu, 19 Jul 2001, David M. Richter wrote:

> Hallo !
> 
> I want to tune a database. There a many redundant datas in the database
> , because of all the relations were consider as n:m relations. But the
> most of them are 1:n Relations. So my approach was to cut the
> redundancies to get more performance. But .. happens!
> 
> The query with the 3 tables is faster than the query with 2 tables. 
> 
> That is paradox to the Explain output.
> And: the real database functions like dbPG95GetIndex and all functions
> defined by me are slower.



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: pl/pgsql - code review + question
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: pl/pgsql - code review + question