Weird performance differences between cloud vendors

Hi, I have run a test with pgbench against two cloud vendors (settings, parameters almost the same). Both Postgres (or whatever they do internally when they call it as Postgres offering, NOT Aurora or so :-) ) I have got a strange result that cloud vendor 1 is performing almost everywher

AW: [External] pg_dump backup verification

Hi, maybe switching on verbose output with -v or -- verbose is a quick and easy help for this? At least you can see something happening. Cheers Dirk Von: Daulat Gesendet: Donnerstag, 25. November 2021 10:12 An: pgsql-performa...@postgresql.org Betreff: [External] pg_dump backup verification

Query Performance in bundled requests

Update: Better title and format corrections Hi %, in order to be able to readjust the effects of the stored procedure and, if necessary, to save turnaround times, different requests can be concatenated using semicolons for bundling several statements in one request. We did some tests against a

AW: Query performance issue

Hi %, in order to be able to readjust the effects of the stored procedure and, if necessary, to save turnaround times, different requests can be concatenated using semicolons for bundling several statements in one request. We did some tests against a postgres cluster. The results in terms of

sizing / capacity planning tipps related to expected request or transactions per second

Hi, are there any nice rules of thumb about capacity planning in relation the expected amount of transactions or request per second? For example, if I have around 100 000 transactions per second on a 5 TB database. With what amount of Memory and CPUs/Cores and which settings would you basically