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

Re: Query performance issue

From: Sushant Sinha <sushant354(at)gmail(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query performance issue
Date: 2011-08-31 09:37:20
Message-ID: 1314783440.1793.0.camel@dragflick (view raw or flat)
Thread:
Lists: pgsql-performance
Where is the query? And also paste the \d to show the tables and
indexes.

-Sushant.

On Wed, 2011-08-31 at 14:30 +0530, Jayadevan M wrote:
> Hello all, 
> I have a query which takes about 20 minutes to execute and retrieves
> 2000-odd records. The explain for the query is pasted here 
> http://explain.depesz.com/s/52f 
> The same query, with similar data structures/indexes and data comes
> back in 50 seconds in Oracle. We just ported the product to PostgreSQL
> and are testing it. Any input on what to look for? 
> 
> Possible relevant parameters are 
> shared_buffers = 4GB                     
> temp_buffers = 8MB                     
> work_mem = 96MB                       
> maintenance_work_mem = 1GB             
> effective_cache_size = 8GB             
> default_statistics_target = 50         
> 
> It is a machine with 16 GB RAM. 
> Regards, 
> Jayadevan
> 
> 
> 
> 
> 
> DISCLAIMER: 
> 
> "The information in this e-mail and any attachment is intended only
> for the person to whom it is addressed and may contain confidential
> and/or privileged material. If you have received this e-mail in error,
> kindly contact the sender and destroy all copies of the original
> communication. IBS makes no warranty, express or implied, nor
> guarantees the accuracy, adequacy or completeness of the information
> contained in this email or any attachment and is not liable for any
> errors, defects, omissions, viruses or for resultant loss or damage,
> if any, direct or indirect."
> 
> 
> 
> 



In response to

pgsql-performance by date

Next:From: Jayadevan MDate: 2011-08-31 10:07:40
Subject: Re: Query performance issue
Previous:From: Heikki LinnakangasDate: 2011-08-31 09:34:28
Subject: Re: Query performance issue

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