Re: WALWriteLocks - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: WALWriteLocks
Date
Msg-id f2fee5feab7766f11814535d4244bb40c18a7b03.camel@cybertec.at
Whole thread Raw
In response to Re: WALWriteLocks  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: WALWriteLocks  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-admin
On Fri, 2021-04-30 at 00:13 +0530, Vijaykumar Jain wrote:
> I tried the below, but i could not simulate WALWriteLock waits.
> 
> create table foo(id int)
> 
>  for i in {1..10}; do  psql -c "begin transaction; insert into foo select 1 from generate_series(1, 1000); commit;" &
done

Perhaps you should do simple inserts of one row and run that script
with a pgbench and lots of clients.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: WALWriteLocks
Next
From: Henry Francisco Garcia Cortez
Date:
Subject: a stop job is running for postgresql cluster 11-main