I have dozens of legacy stored procedures that create temporary tables for collecting results(performance improvement).
I've created a read replica of my Aurora PostgreSQL and tried to execute this procedure, but it failed, as it doesn't allow creating even temporary tables in a read-only transaction.
Are any ways how to solve this issue with minimal effort?
Just converting temp tables to CTE is not effective as they won't give me the performance that temp tables give.
