Re: WALWriteLocks

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>, Don Seiler <don(at)seiler(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WALWriteLocks
Date: 2021-04-29 18:52:03
Message-ID: f2fee5feab7766f11814535d4244bb40c18a7b03.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Henry Francisco Garcia Cortez 2021-04-29 19:48:23 a stop job is running for postgresql cluster 11-main
Previous Message Laurenz Albe 2021-04-29 18:44:35 Re: WALWriteLocks