Re: pg_dump blocks insert update on table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Bindra Bambharoliya <bindra.bambharoliya@xxxxxxxxx>
Subject: Re: pg_dump blocks insert update on table
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 29 Feb 2024 12:59:54 -0500
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Comments: In-reply-to Bindra Bambharoliya <bindra.bambharoliya@xxxxxxxxx> message dated "Thu, 29 Feb 2024 23:07:14 +0530"
In-reply-to: <CAPLVUMBO8AjHbz32VwBMKRv1oBosQP3-XE+-CMm+NBeV=U6dWw@mail.gmail.com>
References: <CABeMV7Pq07Ebe8Guh50qna=Om6mLa6Q6MJC_odagRTfe7WPW-Q@mail.gmail.com> <2711364.1709226898@sss.pgh.pa.us> <CAPLVUMDL6vF=fqtwoLN0HT+GO10jnp6vG8jPdHTr9HfJQ3Vv=w@mail.gmail.com> <CAPLVUMBO8AjHbz32VwBMKRv1oBosQP3-XE+-CMm+NBeV=U6dWw@mail.gmail.com>

Bindra Bambharoliya <bindra.bambharoliya@xxxxxxxxx> writes:
>> Output I got is blocked_statement--call etl_master();

So what kind of lock is that waiting to acquire (blocked_locks.mode)?

			regards, tom lane

References:
- pg_dump blocks insert update on table
  - From: Bindra
- Re: pg_dump blocks insert update on table
  - From: Tom Lane
- Re: pg_dump blocks insert update on table
  - From: Bindra Bambharoliya

Prev by Date: Re: pg_dump blocks insert update on table
Next by Date: Adding custom constraints on a postgres database
Previous by thread: Re: pg_dump blocks insert update on table
Next by thread: Adding custom constraints on a postgres database
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux