Re: Query optimizing - paradox behave - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Query optimizing - paradox behave
Date
Msg-id Pine.BSF.4.21.0107190810000.35685-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Query optimizing - paradox behave  ("David M. Richter" <D.Richter@DKFZ-heidelberg.de>)
List 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 by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: pl/pgsql - code review + question
Next
From: "Josh Berkus"
Date:
Subject: Re: pl/pgsql - code review + question