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

From Andres Freund
Subject Re: BUG #8327: a bug of spgist index in a heavy write condition
Date
Msg-id 20130724110830.GC27288@alap2.anarazel.de
Whole thread Raw
In response to BUG #8327: a bug of spgist index in a heavy write condition  (hailong.li@qunar.com)
Responses Re: BUG #8327: a bug of spgist index in a heavy write condition  (李海龙 <hailong.li@qunar.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: hailong.li@qunar.com
Date:
Subject: BUG #8327: a bug of spgist index in a heavy write condition
Next
From: Willy-Bas Loos
Date:
Subject: Re: BUG #8154: pg_dump throws error beacause of field called "new".