Postgres Pro
Downloads
Home   >   mailing lists

Re: Simply join in PostrgeSQL takes too long - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Simply join in PostrgeSQL takes too long
Date
Msg-id 200404271537.09547.josh@agliodbs.com
Whole thread Raw
In response to Simply join in PostrgeSQL takes too long  (Vitaly Belman <vitalib@012.net.il>)
List pgsql-performance
Tree view 
Vitaly,

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.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Simply join in PostrgeSQL takes too long
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [JDBC] is a good practice to create an index on the