Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin

Поиск
Список
Период
Сортировка
От Ron
Тема Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin
Дата
Msg-id 9ff830d1-1432-bd07-46f0-5975ef88271c@gmail.com
обсуждение исходный текст
Ответ на RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Список pgsql-general
Дерево обсуждения
On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
The problem is users will connect using DBeaver and their sessions 
will sit idle.

Idle is not a problem, "idle in transaction" is.

From my perspective "idle in transaction" isn't necessarily a problem (although I don't like seeing sessions sitting like that for a long time). 

 Well, it is, since you are sitting in an open transaction.

 This fixes it: idle_in_transaction_session_timeout
https://www.postgresql.org/docs/9.6/runtime-config-client.html

-- 
 Born in Arizona, moved to Babylonia.

		
	


	

					

					





	

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

	
	

		
			

	        	

	       			Предыдущее
	    		

	    		
	От:
	"Dirschel, Steve"

	Дата:
	



	Сообщение:
	RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin
 

	    	

	    
	    
	    
			

	        	

	       			Следующее
	    		

	    		
	От:
	Christophe Pettus

	Дата:
	



	Сообщение:
	Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin