(unnamed)

text/html

Filename: (unnamed)

Type: text/html

Part: 0

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

<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>