Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Stored Procedure Performance - Mailing list pgsql-performance

From Adam Brusselback
Subject Re: [PERFORM] Stored Procedure Performance
Date
Msg-id CAMjNa7dQYE44gisjODEWECs82oAjj5Q7pDDhFKmP_aYX3dZYow@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Stored Procedure Performance  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: [PERFORM] Stored Procedure Performance
List pgsql-performance
Tree view
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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [PERFORM] Stored Procedure Performance
Next
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] Stored Procedure Performance