From: Tony Capobianco <tcapobianco@prospectiv.com>
To: pgsql-performance@postgresql.org
Subject: Cursor fetch performance issue
Date: Tue, 24 Jan 2012 15:41:40 -0500
Message-ID: <1327437700.1968.10.camel@tony1.localdomain> (raw)
We are migrating our Oracle warehouse to Postgres 9.
This function responds well:
pg=# select public.getMemberAdminPrevious_sp2(247815829, 1,'test.email@hotmail.com', 'email', 'test');
getmemberadminprevious_sp2
----------------------------
<unnamed portal 1>
(1 row)
Time: 7.549 ms
However, when testing, this fetch takes upwards of 38 minutes:
BEGIN;
select public.getMemberAdminPrevious_sp2(247815829, 1,'test.email@hotmail.com', 'email', 'test');
FETCH ALL IN "<unnamed portal 2>";
How can I diagnose any performance issues with the fetch in the cursor?
Thanks.
Tony
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tcapobianco@prospectiv.com
Subject: Re: Cursor fetch performance issue
In-Reply-To: <1327437700.1968.10.camel@tony1.localdomain>
References: <1327437700.1968.10.camel@tony1.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox