Re: Performance problems inside a stored procedure.

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: <mlunnon(at)rwa-net(dot)co(dot)uk>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance problems inside a stored procedure.
Date: 2008-01-28 12:06:48
Message-ID: 479DC558.30409@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Matthew Lunnon wrote:
> I have a query which runs pretty quick ( 0.82ms) but when I put it
> inside a stored procedure it takes 10 times as long (11.229ms). Is
> this what you would expect and is there any way that I can get around
> this time delay?

It depends. You'll need to show us the function. Also, what version of
Postgres are you running?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Lunnon 2008-01-28 12:10:24 Re: Performance problems inside a stored procedure.
Previous Message Matthew Lunnon 2008-01-28 12:02:26 Performance problems inside a stored procedure.