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