Re: General Performance Question

2021-11-18 Thread Tom Lane
DAVID ROTH writes: > The code I am migrating uses the EXECUTE immediate form for almost > everything. The path of least resistance for me is to just copy the code to > Postgres and change "EXECUTE IMMEDIATE" to "EXECUTE". > I am asking about performance differences to see if it is worth convert

Re: General Performance Question

2021-11-18 Thread DAVID ROTH
Agreed. The code I am migrating uses the EXECUTE immediate form for almost everything. The path of least resistance for me is to just copy the code to Postgres and change "EXECUTE IMMEDIATE" to "EXECUTE". I am asking about performance differences to see if it is worth converting code that does

Re: General Performance Question

2021-11-18 Thread Thomas Kellerer
DAVID ROTH schrieb am 18.11.2021 um 15:15: > I am working on a large Oracle to Postgres migration. > The existing code frequently constructs a string and then uses Oracle's > "EXECUTE IMMEDIATE" to run it. > "EXECUTE" has the same functionality in Postgres. > > For example: > CREATE or REPLACE FUN