Re: [PERFORM] Stored Procedure Performance

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PERFORM] Stored Procedure Performance
Дата
Msg-id CAFj8pRB32vGfzOuQy8ZC03Jvgx8hKL4_P7Zv4oO_w0dmUKbP-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Stored Procedure Performance  (Adam Brusselback <adambrusselback@gmail.com>)
Ответы Re: [PERFORM] Stored Procedure Performance
Список pgsql-performance
Дерево обсуждения


2017-10-03 17:17 GMT+02:00 Adam Brusselback <adambrusselback@gmail.com>:
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.

depends what is inside.

The max 10x slow down is possible if you are hit some unoptimized cases. The times about 1ms - 10ms shows so procedure (code) can be very sensitive to some impacts.

Regards

Pavel

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

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance
Следующее
От: Ben Nachtrieb
Дата:
Сообщение: [PERFORM] How does max_parallel_workers_per_gather change load averages?