Re: indexing for left join

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: indexing for left join
Date: 2006-01-19 16:42:04
Message-ID: 43CFC15C.7010808@numerixtechnology.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2006-01-19 16:42:18 Re: indexing for left join
Previous Message Rod Taylor 2006-01-19 15:57:09 Re: indexing for left join