Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s0mSf-007Euv-2V for pgsql-general@arkaria.postgresql.org; Sat, 27 Apr 2024 18:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s0mSa-009PNY-KR for pgsql-general@arkaria.postgresql.org; Sat, 27 Apr 2024 18:07:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s0mSa-009PNO-6K for pgsql-general@lists.postgresql.org; Sat, 27 Apr 2024 18:07:41 +0000 Received: from mail-pf1-x42b.google.com ([2607:f8b0:4864:20::42b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s0mSV-000Ngz-I4 for pgsql-general@lists.postgresql.org; Sat, 27 Apr 2024 18:07:40 +0000 Received: by mail-pf1-x42b.google.com with SMTP id d2e1a72fcca58-6ecff9df447so3218093b3a.1 for ; Sat, 27 Apr 2024 11:07:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714241253; x=1714846053; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=xAwQOMBnkUsvxohxv5mPwqJ1YUUJZ9SD/gqs0kyy1qY=; b=GlkZAq4RM+QldjYxRPmYTyKLJzrR/0ZNguzTs8d163NC++F27K85Ly9lQVNqLl7ns5 mYvncvfCpoT9P7tqFpPg5pKUcfIdxIepHceSRyMhdwmJ+9tu3E/xIEzggiNNllumvRKr cMdPRQA1VIQtLKfAuZd8XZJgbZrpj7sb5WcSxr0aVfUvA6aDT7TZdkA43VkbDGNM4Ptr dIzXQjXjv1cbZ/HblTE6CcEtbuOgKQKC9366Qd51LI5HjOXglJQUQXdq30hrS9Qtp8rP UWNRmsChiShO+ZcttcX/TtlrTwn9yUB7wNVXj95KWSRXU4BLT/yS5sYhFbKH3p8yiit1 Th2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714241253; x=1714846053; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=xAwQOMBnkUsvxohxv5mPwqJ1YUUJZ9SD/gqs0kyy1qY=; b=IhalsRd28xzXlhZKxMy7igyZK+68wk1lbHEwBtMZVFGbRhAUuW3EHnxSTwpdcjQKMl nuc8CGtmXdCwOgrPxpMXJwf8fn9+GGd82OBmJD5aScSGZkYcX/hE2fCNMZic+1dqeEdk CDO5zfYd3UqPrXj4TpQ+jmT69oNPdOOnhrQQgi2/a23IAFyUXUkvTD+9o/Lgz0JEv35h moBzpdsO+SmWqljyc/Slqy5rA5OSH/S6wPtDk2DlTcwwqig2mPd+SEehQN9Zp9vzErq0 I9Bw/jGrMJZq7LmOZhWDe73EvOesCKlzN0obVvkZHJ1/aeaWQEDeXIVUVAsc3rXMjUJ/ NMEg== X-Gm-Message-State: AOJu0YxrIA1URaLnREqYjEJ4axzotHxTrOZWt3SAInmaWnvzGIN5W9ql v+gNexfyXBFBuePnnxUcF/S4GyxdR3lNB1Lumb43qlyHubdukBtQPDwl1DFy72lsrQlhVCBg8oq F5XCl9bAvUMOavWljo1d3pqFJlJdO9g== X-Google-Smtp-Source: AGHT+IEua/vq1uj5kk8TLR2rByMHQb3w80iaXRXcnC/PXLzXuBHeWZFaMfhvAunI85UBNpRk+MCm30Rrx7WzOviCUPA= X-Received: by 2002:a05:6a20:d487:b0:1af:41d1:7334 with SMTP id im7-20020a056a20d48700b001af41d17334mr1204223pzb.27.1714241252987; Sat, 27 Apr 2024 11:07:32 -0700 (PDT) MIME-Version: 1.0 From: Sasmit Utkarsh Date: Sat, 27 Apr 2024 23:37:20 +0530 Message-ID: Subject: Stess test via libpq for postgreSQL DB To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000f1a0f8061717e4cd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f1a0f8061717e4cd Content-Type: text/plain; charset="UTF-8" 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 --000000000000f1a0f8061717e4cd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Postgresql Team,

Could you please he= lp on how to get started with some stress test for my application which use= s libpq to interact with postgres flexi db. I tried to explore pgbench whic= h is a builtin tool to get some stats. But i have some clarifications=C2=A0= if we can use it to execute PLSQL=C2=A0code blocks rather than standalone S= QL queries. Please advise


<= div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature= ">
Regards,
Sasmit Utkarsh
+91= -7674022625
--000000000000f1a0f8061717e4cd--