Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Performance problems inside a stored procedure.
- From: Matthew Lunnon <mlunnon(at)rwa-net(dot)co(dot)uk>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Performance problems inside a stored procedure.
- Date: Mon, 28 Jan 2008 12:02:26 +0000
Hi msI 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?
postgres.conf changes. shared_buffers = 500MB work_mem = 10MB maintenance_work_mem = 100MB effective_cache_size = 2048MB default_statistics_target = 1000 Thanks for any help. Regards Matthew.
- Follow-Ups:
- Re: Performance problems inside a stored procedure.
- From: Heikki Linnakangas
- Re: Performance problems inside a stored procedure.
- Prev by Date: Performance issues migrating from 743 to 826
- Next by Date: Re: Performance problems inside a stored procedure.
- Previous by thread: Performance issues migrating from 743 to 826
- Next by thread: Re: Performance problems inside a stored procedure.
- Indexes: