agora inbox for pgsql-performance@postgresql.org  

help / color / mirror / Atom feed

From: Sushant Sinha <sushant354@gmail.com>
To: Jayadevan M <Jayadevan.Maymala@ibsplc.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Query performance issue
Date: Wed, 31 Aug 2011 15:07:20 +0530
Message-ID: <1314783440.1793.0.camel@dragflick> (raw)
In-Reply-To: <OF6B813C80.12B50253-ON652578FD.00310FC3-652578FD.00317C74@ibsplc.com>
References: <OF6B813C80.12B50253-ON652578FD.00310FC3-652578FD.00317C74@ibsplc.com>

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."
> 
> 
> 
> 

view thread (57+ messages)  latest in thread

Message-ID: <1314783440.1793.0.camel@dragflick>
Permalink:  ../1314783440.1793.0.camel@dragflick/
Also on:    postgresql.org/message-id/1314783440.1793.0.camel@dragflick

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sushant354@gmail.com, Jayadevan.Maymala@ibsplc.com
  Subject: Re: Query performance issue
  In-Reply-To: <1314783440.1793.0.camel@dragflick>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox