CODEWITHSUNDEEP
postgresqllockspgbench
Firas Megrahi
Firas Megrahi

Reputation: 97

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.

Upvotes: 0

Views: 320

Answers (1)

user330315
user330315

Reputation:

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

Upvotes: 2

Related Questions