Re: BUG #8327: a bug of spgist index in a heavy write condition

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: hailong(dot)li(at)qunar(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8327: a bug of spgist index in a heavy write condition
Date: 2013-07-24 11:08:30
Message-ID: 20130724110830.GC27288@alap2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On 2013-07-24 10:54:07 +0000, hailong(dot)li(at)qunar(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8327
> Logged by: hailong.li
> Email address: hailong(dot)li(at)qunar(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Willy-Bas Loos 2013-07-24 12:18:17 Re: BUG #8154: pg_dump throws error beacause of field called "new".
Previous Message hailong.li 2013-07-24 10:54:07 BUG #8327: a bug of spgist index in a heavy write condition