Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 28 Jan 2008 12:06:48 +0000
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
- Follow-Ups:
- Re: Performance problems inside a stored procedure.
- From: Matthew Lunnon
- Re: Performance problems inside a stored procedure.
- References:
- Performance problems inside a stored procedure.
- From: Matthew Lunnon
- Performance problems inside a stored procedure.
- Prev by Date: Performance problems inside a stored procedure.
- Next by Date: Re: Performance problems inside a stored procedure.
- Previous by thread: Performance problems inside a stored procedure.
- Next by thread: Re: Performance problems inside a stored procedure.
- Indexes: