Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group