Re: indexing for left join

From: Rod Taylor <pg(at)rbt(dot)ca>
To: mailreg(at)numerixtechnology(dot)de
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: indexing for left join
Date: 2006-01-19 15:57:09
Message-ID: 1137686229.15377.303.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> 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).
--

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2006-01-19 16:42:04 Re: indexing for left join
Previous Message Richard Huxton 2006-01-19 15:52:45 Re: indexing for left join