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

From: "chjischj(at)163(dot)com" <chjischj(at)163(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock
Date: 2018-11-12 01:46:08
Message-ID: xxs2ys-tbwrafao0r8r-7u8o3sw2ceghwk10xo8ji0hg-lkpbexyg2ft42t1jcy1epz8pfg87sx-79m4ap-78mougkms51h1d04kl-oc90r6-ud3qo8a3bis39y7zz0l9u5dryjxakz6gugngbcwex9.1541987168029@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<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(at)163(dot)com><pg(at)bowt(dot)ie><teodor(at)sigaev(dot)ru><pgsql-hackers(at)lists(dot)postgresql(dot)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(at)lists(dot)postgresql(dot)org></teodor(at)sigaev(dot)ru></pg(at)bowt(dot)ie></chjischj(at)163(dot)com></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matsumura, Ryo 2018-11-12 02:14:58 RE: [PROPOSAL]a new data type 'bytea' for ECPG
Previous Message Melanie Plageman 2018-11-11 23:30:37 Re: [HACKERS] [PATCH v2] Add and report the new "session_read_only" GUC pseudo-variable.