Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE

Поиск

Список

Период

Сортировка

От	M Sarwar
Тема	Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
Дата	6 июня 00:23:05
Msg-id	DM4PR19MB59783696112303CE33432F22D3F92@DM4PR19MB5978.namprd19.prod.outlook.com обсуждение исходный текст
Ответы	Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE
Список	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

В списке pgsql-admin по дате отправления:

От: Ron Johnson
Дата: 05 июня, 15:22:26
Сообщение: Re: Minimize checkpointer and walwriter io during pg_restore

От: Tom Lane
Дата: 06 июня, 00:39:45
Сообщение: Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE