Re: BUG #8327: a bug of spgist index in a heavy write condition - Mailing list pgsql-bugs

From 李海龙
Subject Re: BUG #8327: a bug of spgist index in a heavy write condition
Date
Msg-id 5201EE46.4070401@qunar.com
Whole thread Raw
In response to Re: BUG #8327: a bug of spgist index in a heavy write condition  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
<div class="moz-cite-prefix"><b>My dear Tom Lane && pgsql-hackers<br /><br /></b><br /> Thanks very very
much!<br/><br /> I have modified  the postgres source code that Tom lane fixed, and the origin phenomenon of that bug
nolonger appears in my old test case.<b><br /><br /><br /> Thanks again!<br /><br /> Best Regards!<br /><br /><br
/></b><br/> at 2013-07-24 19:08, Andres Freund wrote:<br /></div><blockquote
cite="mid:20130724110830.GC27288@alap2.anarazel.de"type="cite"><pre wrap="">Hi,
 

On 2013-07-24 10:54:07 +0000, <a class="moz-txt-link-abbreviated"
href="mailto:hailong.li@qunar.com">hailong.li@qunar.com</a>wrote:
 
</pre><blockquote type="cite"><pre wrap="">The following bug has been logged on the website:

Bug reference:      8327
Logged by:          hailong.li
Email address:      <a class="moz-txt-link-abbreviated" href="mailto:hailong.li@qunar.com">hailong.li@qunar.com</a>
PostgreSQL version: 9.2.4
Operating system:   CentOS release 5.5 (Final)
Description:        

<a class="moz-txt-link-freetext"
href="http://www.postgresql.org/message-id/519A5917.40704@qunar.com">http://www.postgresql.org/message-id/519A5917.40704@qunar.com</a>
</pre></blockquote><pre wrap="">
There's a thread that discussed the issue on the -hackers list:
<a class="moz-txt-link-freetext"
href="http://archives.postgresql.org/message-id/5829.1370555205%40sss.pgh.pa.us">http://archives.postgresql.org/message-id/5829.1370555205%40sss.pgh.pa.us</a>

This resulted in a fix:
<a class="moz-txt-link-freetext"
href="http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e472b921406407794bab911c64655b8b82375196">http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e472b921406407794bab911c64655b8b82375196</a>
Which has also been backported to the 9.2 branch. There hasn't been a
release since the commit though.

Greetings,

Andres Freund

</pre></blockquote><br />

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #8366: getClob() stopped working from which version?
Next
From: Sebastian Kornehl
Date:
Subject: Reltuples/n_live_tup values wrong