On Wed, 2006-06-21 at 08:47, nicky wrote:
> Hello People,
SNIPPAGE
> The query above takes around 42 minutes.
>
> However, i also have a wimpy desktop machine with 1gb ram. Windows
> with MSSQL 2000 (default installation), same database structure, same
> indexes, same query, etc and it takes 17 minutes. The big difference
> makes me think that i've made an error with my PostgreSQL
> configuration. I just can't seem to figure it out.
What is the difference between the two plans (i.e. explain on both boxes
and compare)