Postgres Pro
Downloads
Home   >   mailing lists

Re: slow SP with temporary tables, any idea of solution? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: slow SP with temporary tables, any idea of solution?
Date
Msg-id 26747.1108048406@sss.pgh.pa.us
Whole thread Raw
In response to slow SP with temporary tables, any idea of solution?  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Responses Re: slow SP with temporary tables, PLPGSQL problems  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: How can I use large object on PostgreSQL Linux
Next
From: pgsql@mohawksoft.com
Date:
Subject: New form of index "persistent reference"