Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards.

med Prepared Statements". We appreciate your attention and look forward to your guidance and suggestions for resolving this problem. We have attached a small C program with libpq that demonstrates this issue, along with the program's output and the execution of the "ps aux"

Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards.

o your guidance and suggestions for resolving this problem. We have attached a small C program with libpq that demonstrates this issue, along with the program's output and the execution of the "ps aux" program. Best regards, Daniel Bla

Re: increase insert into local table from remote oracle table preformance

The Postgres command of choice to load bulk data is COPY https://www.postgresql.org/docs/current/static/sql-copy.html is much faster than anything else. It’s likely that the slowest part could be Oracle exporting it’s data. Try to