Re: slow SP with temporary tables, any idea of solution?

Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> Can you help me other possibilities?

Create the temp table only once per connection (you can use ON COMMIT
DELETE ROWS instead of ON COMMIT DROP to clean it out).  Then you won't
need to use EXECUTE.
        regards, tom lane