Cursor fetch performance issue - Mailing list pgsql-performance

From Tony Capobianco
Subject Cursor fetch performance issue
Date
Msg-id 1327437700.1968.10.camel@tony1.localdomain
Whole thread Raw
Responses Re: Cursor fetch performance issue
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Can lots of small writes badly hamper reads from other tables?
Next
From: Pavel Stehule
Date:
Subject: Re: Cursor fetch performance issue