agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Heikki Linnakangas <heikki.linnakangas@enterprisedb.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 12:34:28 +0300
Message-ID: <4E5E0024.9070801@enterprisedb.com> (raw)
In-Reply-To: <OF6B813C80.12B50253-ON652578FD.00310FC3-652578FD.00317C74@ibsplc.com>
References: <OF6B813C80.12B50253-ON652578FD.00310FC3-652578FD.00317C74@ibsplc.com>
On 31.08.2011 12:00, 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.
Please run EXPLAIN ANALYZE on the query and post that, it's hard to say
what's wrong from just the query plan, without knowing where the time is
actually spent. And the schema of the tables involved, and any indexes
on them. (see also http://wiki.postgresql.org/wiki/SlowQueryQuestions)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
view thread (57+ messages) latest in thread
Message-ID: <4E5E0024.9070801@enterprisedb.com>
Permalink: ../4E5E0024.9070801@enterprisedb.com/
Also on: postgresql.org/message-id/4E5E0024.9070801@enterprisedb.com
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: heikki.linnakangas@enterprisedb.com, Jayadevan.Maymala@ibsplc.com
Subject: Re: Query performance issue
In-Reply-To: <4E5E0024.9070801@enterprisedb.com>
* 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