Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: [PERFORM] Stored Procedure Performance
Date
Msg-id CAFj8pRB32vGfzOuQy8ZC03Jvgx8hKL4_P7Zv4oO_w0dmUKbP-w@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Stored Procedure Performance  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: [PERFORM] Stored Procedure Performance
List pgsql-performance
Tree view


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 by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: [PERFORM] Stored Procedure Performance
Next
From: Ben Nachtrieb
Date:
Subject: [PERFORM] How does max_parallel_workers_per_gather change load averages?