[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BUG #15253: DROP/select/update query  waiting for pg_dump
From:       Andres Freund <andres () anarazel ! de>
Date:       2018-06-27 15:01:34
Message-ID: 20180627150134.lphsddetwachkrkj () alap3 ! anarazel ! de
[Download RAW message or body]

Hi,

On 2018-06-27 14:01:09 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      15253
> Logged by:          NIRBAN SEN
> Email address:      sennirban89@gmail.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   rhel7
> Description:        
> 
> DROP/select/update queries are going into waiting state when pg_dump is
> running.

DROP TABLE, and many other kinds of DDL, are indeed going to be blocked
by a concurrent pg_dump. That's expected and not a bug.  SELECT / UPDATE
on their own won't.

Please note that the form you used is for reporting a bug, but I do not
see one in your report?

Greetings,

Andres Freund

[prev in list] [next in list] [prev in thread] [next in thread]