Re: function slower than the same code in an sql file

From: Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: CS DBA <cs_dba(at)consistentstate(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: function slower than the same code in an sql file
Date: 2011-11-03 15:31:59
Message-ID: 4EB2B3EF.60502@estrads.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

El 03/11/11 11:42, Robert Haas escribió:
> On Fri, Oct 28, 2011 at 9:39 AM, CS DBA<cs_dba(at)consistentstate(dot)com> wrote:
>> No parameters, one of them looks like this:
>>
>> [ code snippet ]
> It's hard to believe this is the real code, because SELECT without
> INTO will bomb out inside a PL/pgsql function, won't it?
>
But he's using CREATE TABLE xyz_view_m AS

So it seems correct to me

Regards

Rodrigo

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-11-03 15:35:00 Re: Query running a lot faster with enable_nestloop=false
Previous Message Mario Weilguni 2011-11-03 15:02:07 Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!