Обсуждение: BUG #8327: a bug of spgist index in a heavy write condition
The following bug has been logged on the website: Bug reference: 8327 Logged by: hailong.li Email address: hailong.li@qunar.com PostgreSQL version: 9.2.4 Operating system: CentOS release 5.5 (Final) Description: http://www.postgresql.org/message-id/519A5917.40704@qunar.com
Hi, On 2013-07-24 10:54:07 +0000, hailong.li@qunar.com wrote: > The following bug has been logged on the website: > > Bug reference: 8327 > Logged by: hailong.li > Email address: hailong.li@qunar.com > PostgreSQL version: 9.2.4 > Operating system: CentOS release 5.5 (Final) > Description: > > http://www.postgresql.org/message-id/519A5917.40704@qunar.com There's a thread that discussed the issue on the -hackers list: http://archives.postgresql.org/message-id/5829.1370555205%40sss.pgh.pa.us This resulted in a fix: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e472b921406407794bab911c64655b8b82375196 Which has also been backported to the 9.2 branch. There hasn't been a release since the commit though. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
<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 />