| 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
>
>
| 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 |