Message-ID: <b7dcfa5c-846b-408c-9da3-201638aee2e1@blackbrook.org>
Date: Mon, 9 Dec 2024 13:42:30 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
Content-Language: en-US
From: Eric Schwarzenbach <subscriber@blackbrook.org>
Subject: can a blocked transaction affect the performance of one that is
 blocking it?
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/b7dcfa5c-846b-408c-9da3-201638aee2e1%40blackbrook.org>
Precedence: bulk

Hi,

Could one transaction (one that should be relatively simple and short) 
cause another complex, long running transaction (involving INSERTS, on a 
table the first transaction may be reading from) to take many orders of 
magnitude longer than it would normally? (short of competing for system 
resources, like CPU time etc, of course)

I don't believe my scenario involved a deadlock but I expect my short 
transaction was probably blocked by my long one. Does it make any sense 
that this could very significantly affect the performance of the 
non-blocked transaction?

Thanks,

Eric