Re: function slower than the same code in an sql file - Mailing list pgsql-performance

From Rodrigo Gonzalez
Subject Re: function slower than the same code in an sql file
Date
Msg-id 4EB2B3EF.60502@estrads.com.ar
Whole thread Raw
In response to Re: function slower than the same code in an sql file  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: function slower than the same code in an sql file
List pgsql-performance
El 03/11/11 11:42, Robert Haas escribió:
On Fri, Oct 28, 2011 at 9:39 AM, CS DBA <cs_dba@consistentstate.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

pgsql-performance by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Next
From: Robert Haas
Date:
Subject: Re: Query running a lot faster with enable_nestloop=false