Re: [HACKERS] slow SP with temporary tables, PLPGSQL problems

2005-02-13 Thread Pavel Stehule
> > 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. > > I am sorry, first time I didn't understand. Now I did some test and its good adivice. Sometimes I have problem underst

Re: [HACKERS] slow SP with temporary tables, PLPGSQL problems

2005-02-10 Thread Pavel Stehule
> Pavel Stehule <[EMAIL PROTECTED]> 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. > I am not sure so it's possible. I use p