Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2013

    Unanswered: Using refcursors

    I have problem with refcursor as pgplsql functions returning type. If part of data returning by function like that is small everything works fine, but if i have set of data size more than 1000 i have big problem with performance. This functions return result partial, 10 - 100 records at ones and when i try to return flew thousand records it`s taking to much time. I seek configurations like buffer size, or something else to have a better performace with functions returns recursor. Please help. I need the solution on yesterday. I'm using postgresql 8.3.
    Last edited by Gabriel81; 03-16-13 at 14:46.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts