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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: slow SP with temporary tables, any idea of solution?
Date: 2005-02-10 15:13:26
Message-ID: 26747.1108048406@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2005-02-10 16:21:48 New form of index "persistent reference"
Previous Message Andreas Pflug 2005-02-10 13:08:42 Re: How can I use large object on PostgreSQL Linux