Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problems inside a stored procedure. - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Performance problems inside a stored procedure.
Date
Msg-id 479DC558.30409@enterprisedb.com
Whole thread Raw
In response to Performance problems inside a stored procedure.  (Matthew Lunnon <mlunnon@rwa-net.co.uk>)
Responses Re: Performance problems inside a stored procedure.
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Matthew Lunnon
Date:
Subject: Performance problems inside a stored procedure.
Next
From: Matthew Lunnon
Date:
Subject: Re: Performance problems inside a stored procedure.