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

From Rod Taylor
Subject Re: indexing for left join
Date
Msg-id 1137686229.15377.303.camel@home
Whole thread Raw
In response to indexing for left join  (T E Schmitz <mailreg@numerixtechnology.de>)
Responses Re: indexing for left join  (T E Schmitz <mailreg@numerixtechnology.de>)
List 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).
-- 



pgsql-sql by date:

Previous
From: T E Schmitz
Date:
Subject: indexing for left join
Next
From: Richard Huxton
Date:
Subject: Re: indexing for left join