Postgres Pro
Downloads
Home   >   mailing lists

Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED - Mailing list pgsql-performance

From Michael Lewis
Subject Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Date
Msg-id CAHOFxGp_r5=TLNJX7insLP=L=o24tojKnopRo9fvzKPFxJi8Ww@mail.gmail.com
Whole thread Raw
In response to Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED  (Jim Jarvie <jim@talentstack.to>)
Responses Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
List pgsql-performance
Tree view
Can you share an explain analyze for the query that does the select for update? I wouldn't assume that partition pruning is possible at all with hash, and it would be interesting to see how it is finding those rows.

		
	


	

					

					





	

	pgsql-performance by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	Jim Jarvie

	Date:
	



	Subject:
	Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Jim Jarvie

	Date:
	



	Subject:
	Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED