Horton

Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock

chenhj <chjischj@163.com>

View thread View on postgr.es
From: "chjischj@163.com" <chjischj@163.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Teodor Sigaev <teodor@sigaev.ru>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-11-12T01:46:08Z
Lists: pgsql-hackers

Attachments

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><div class="quote" style="line-height: 1.5"><br></div><div class="quote" style="line-height: 1.5">There's a mistake in the last mail.</div><div class="quote" style="line-height: 1.5">About how to reproduct the issue,the following SQL should be:</div><div class="quote" style="line-height: 1.5"><br></div><div class="quote" style="line-height: 1.5">set enable_seqscan = false;</div><div class="quote" style="line-height: 1.5"><chjischj@163.com><pg@bowt.ie><teodor@sigaev.ru><pgsql-hackers@lists.postgresql.org>select count(*) from tb1 where id =1;<br><br><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><br><div>4. execute select SQL</div><div><br></div><div>&nbsp; &nbsp; set enable_seqscan = false;</div><div>&nbsp; &nbsp; select count(*) from tb1 where id =2;</div><div><br></div><div>Regard,</div><div>Chen Huajun</div></div></blockquote></pgsql-hackers@lists.postgresql.org></teodor@sigaev.ru></pg@bowt.ie></chjischj@163.com></div></body></html>

Commits

  1. Fix WAL format incompatibility introduced by backpatching of 52ac6cd2d0

  2. Fix wrong backpatching of ginRedoDeletePage() deadlock fix

  3. Fix deadlock in GIN vacuum introduced by 218f51584d5

  4. Prevent GIN deleted pages from being reclaimed too early

  5. Prevent deadlock in ginRedoDeletePage()

  6. Reduce page locking in GIN vacuum

  7. Fix race condition in GIN posting tree page deletion.