Re: indexing for left join - Mailing list pgsql-sql

From T E Schmitz
Subject Re: indexing for left join
Date
Msg-id 43CFC15C.7010808@numerixtechnology.de
Whole thread Raw
In response to Re: indexing for left join  (Rod Taylor <pg@rbt.ca>)
List pgsql-sql
Rod Taylor wrote:
>>Sequential despite the indices? Or is this because the tables of my test 
>>DB are virtually empty?
> 
> 
> This is it. PostgreSQL changes strategies with data load. Performance
> testing must be done on an approximation of the real data (both values
> and size).

Thanks for your responses.

-- 


Regards,

Tarlika Elisabeth Schmitz



pgsql-sql by date:

Previous
From: T E Schmitz
Date:
Subject: Re: indexing for left join
Next
From: Michael Glaesemann
Date:
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"