Re: Simply join in PostrgeSQL takes too long

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Vitaly Belman <vitalib(at)012(dot)net(dot)il>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Simply join in PostrgeSQL takes too long
Date: 2004-04-27 22:37:09
Message-ID: 200404271537.09547.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-04-28 01:30:44 Re: [JDBC] [PERFORM] is a good practice to create an index on the
Previous Message Rod Taylor 2004-04-27 22:01:34 Re: Simply join in PostrgeSQL takes too long