Re: I s this a bug of spgist index in a heavy write condition?

From: 李海龙 <hailong(dot)li(at)qunar(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: 何伟平 <weiping(dot)he(at)qunar(dot)com>, 王冬 <dong(dot)wang(at)qunar(dot)com>, 于超超 <chaochao(dot)yu(at)qunar(dot)com>
Subject: Re: I s this a bug of spgist index in a heavy write condition?
Date: 2012-12-14 04:00:20
Message-ID: 50CAA452.1060602@qunar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi,

The problem is not always appear on our system, we can't find a way to
reproduce it.
After rebuild the index with btree, the problem is disappear

at 2012-12-14 00:16, Tom Lane wrote:
> =?utf-8?B?5p2O5rW36b6Z?= <hailong(dot)li(at)qunar(dot)com> writes:
>> We have lots data to insert in that table which have the spgist index,
>> may be the spgist index have a bug on a heavy write condition?
> Perhaps, but you certainly haven't provided any information that would
> help anyone to fix the bug. Can you create a self-contained test case?
>
> regards, tom lane
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2012-12-14 04:03:14 Re: Multiple --table options for other commands
Previous Message Michael Paquier 2012-12-14 03:40:36 Re: logical decoding - GetOldestXmin