I'm afraid that your helper on DevShed is right; 7.5 for Windows is still in
development, we've not even *started* to check it for performance yet.
Since the Merge Join is taking 90% of your query time, I might suggest
increasing shared_buffers and sort_mem to see if that helps.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Christopher Kings-Lynne||Date: 2004-04-28 01:30:44|
|Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the|
|Previous:||From: Rod Taylor||Date: 2004-04-27 22:01:34|
|Subject: Re: Simply join in PostrgeSQL takes too long|