On Wed, 2006-06-21 at 08:47, nicky wrote:
> Hello People,
> 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
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-06-21 17:12:11|
|Subject: Re: Speeding up query, Joining 55mil and 43mil records. |
|Previous:||From: jody brownell||Date: 2006-06-21 16:49:49|
|Subject: Re: Help tuning autovacuum - seeing lots of relationbloat|