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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: CS DBA <cs_dba(at)consistentstate(dot)com>
Cc: 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 14:42:31
Message-ID: CA+TgmoanpOaQS5112U2YBq0b81Ssoxs+MVi-3O+d9ftEKjL7pA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albe Laurenz 2011-11-03 14:48:11 Re: SSL encryption makes bytea transfer slow
Previous Message Yeb Havinga 2011-11-03 14:40:56 Re: Intel 710 pgbench write latencies