Stess test via libpq for postgreSQL DB

Started by Sasmit Utkarshalmost 2 years ago3 messagesgeneral
Jump to latest
#1Sasmit Utkarsh
utkarshsasmit@gmail.com

Hi Postgresql Team,

Could you please help on how to get started with some stress test for my
application which uses libpq to interact with postgres flexi db. I tried to
explore pgbench which is a builtin tool to get some stats. But i have some
clarifications if we can use it to execute PLSQL code blocks rather than
standalone SQL queries. Please advise

Regards,
Sasmit Utkarsh
+91-7674022625

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Sasmit Utkarsh (#1)
Re: Stess test via libpq for postgreSQL DB

On Sat, Apr 27, 2024 at 11:07 AM Sasmit Utkarsh <utkarshsasmit@gmail.com>
wrote:

But i have some clarifications if we can use it to execute PLSQL code
blocks rather than standalone SQL queries.

https://www.postgresql.org/docs/current/sql-do.html

David J.

#3Sasmit Utkarsh
utkarshsasmit@gmail.com
In reply to: David G. Johnston (#2)
Re: Stess test via libpq for postgreSQL DB

Thanks David

Regards,
Sasmit Utkarsh
+91-7674022625

On Sat, Apr 27, 2024 at 11:44 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:

Show quoted text

On Sat, Apr 27, 2024 at 11:07 AM Sasmit Utkarsh <utkarshsasmit@gmail.com>
wrote:

But i have some clarifications if we can use it to execute PLSQL code
blocks rather than standalone SQL queries.

https://www.postgresql.org/docs/current/sql-do.html

David J.