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)
