[GENERAL] optimising the pl/pgsql function - Mailing list pgsql-general

From VENKTESH GUTTEDAR
Subject [GENERAL] optimising the pl/pgsql function
Date
Msg-id CA+iwz4mBhHLT1KgMeUViZ+6QVEmVxN99+c_a4SmN4edBrLGBDw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] optimising the pl/pgsql function  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Hello,

    We are running a pretty big plsql function, we are fetching data from some tables based on certain conditions. And using that data in a for loop within the function.
the problem we are facing is when the no of records are more the function ction is taking too much time, is there a solution to this problem? Can we replace the for loop with something else?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Code of Conduct
Next
From: marcelo
Date:
Subject: Re: Select into table%ROWTYPE failed