Re: [PERFORM] Stored Procedure Performance

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: [PERFORM] Stored Procedure Performance
Дата
Msg-id CAMjNa7dQYE44gisjODEWECs82oAjj5Q7pDDhFKmP_aYX3dZYow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Stored Procedure Performance  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: [PERFORM] Stored Procedure Performance  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
Дерево обсуждения
There is also the option of pg_stat_statements: https://www.postgresql.org/docs/current/static/pgstatstatements.html and auto_explain: https://www.postgresql.org/docs/current/static/auto-explain.html

These should help you identify what is slowing things down.  There is no reason I could think of you should be seeing a 10x slowdown between Postgres and Oracle, so you'll likely have to just profile it to find out.

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance