Performance problems inside a stored procedure.

Поиск
Список
Период
Сортировка
От Matthew Lunnon
Тема Performance problems inside a stored procedure.
Дата
Msg-id 479DC452.8010400@rwa-net.co.uk
обсуждение исходный текст
Ответы Re: Performance problems inside a stored procedure.  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список 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.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Matthew Lunnon
Дата:
Сообщение: Performance issues migrating from 743 to 826
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Performance problems inside a stored procedure.