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: 2008-01-28 12:02:26
Message-ID: 479DC452.8010400@rwa-net.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi ms

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?

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2008-01-28 12:06:48 Re: Performance problems inside a stored procedure.
Previous Message Matthew Lunnon 2008-01-28 11:41:41 Performance issues migrating from 743 to 826