Home > mailing lists

Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE - Mailing list pgsql-admin

From	M Sarwar
Subject	Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
Date	June 6 00:23:05
Msg-id	DM4PR19MB59783696112303CE33432F22D3F92@DM4PR19MB5978.namprd19.prod.outlook.com Whole thread Raw
Responses	Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
List	pgsql-admin

Hello,

Today I have an interesting observation.

I am truncating the table DUMMY_mid .

Truncate is getting struck due to DELETE operation on the table DUMMY_init.

When I take a look at the PG_STAT_ACTIVITY table, it is confirmed that the TRUNCATE is blocked by DELETE on DUMMY_INIT table.

This seems to be strange to me.

Thanks,

Sarwar

From: Ron Johnson
Date: 05 June, 15:22:26
Subject: Re: Minimize checkpointer and walwriter io during pg_restore

From: Tom Lane
Date: 06 June, 00:39:45
Subject: Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE