postgresqllockspgbench

Does Pgbench modify the database?

I'm trying to generate "locks" in my postgresql database, i used pgbench to create an activity in the database while lanching a vacuum full or reindex to generate some process "locks" and nothing happened ...

so i'm not sure if pgbench creates a "real" activity in the database,

Thanks in advance for your answers.

Solution

  • Yes, it does as documented in the manual

    By default, pgbench tests a scenario that is loosely based on TPC-B, involving five SELECT, UPDATE, and INSERT commands per transaction