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

at 2013-01-12 02:21, Tom Lane wrote: =?gb2312?B?wO66o8H6?= writes: This time I will give you the contents of the table route_raw, the download link is https://www.box.com/s/yxa4yxo6rcb3dzeaefmz or http://dl.dropbox.com/u/203288/route_raw_spgist.sql.tar.gz . Th

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

=?gb2312?B?wO66o8H6?= writes: > This time I will give you the contents of the table route_raw, the download > link is https://www.box.com/s/yxa4yxo6rcb3dzeaefmz or > http://dl.dropbox.com/u/203288/route_raw_spgist.sql.tar.gz . Thanks for the data, but I still can't reproduce the problem :-(.

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

Hi,dear tom lane && pgsql-hackers In your last e-mail, you want me to think anbout the only spgist-indexed column and give you some more further information. This time I will give you the contents of the table route_raw, the download link is https://www.box.com/s/yxa4yxo6rcb3dzeaefmz or htt

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

I wrote: > The control flow in spgdoinsert.c is flat enough that the stack trace > alone isn't much help in understanding the bug, I'm afraid. BTW, something that possibly *would* help, since you seem to be able to reproduce the bug easily, is to do that and then capture the values of the local va

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

=?gb2312?B?wO66o8H6?= writes: > I am very excited to say that I may have created a test case! I've been running variants of this example for most of the afternoon, and have not seen a failure :-(. So I'm afraid there is some aspect of your situation that you've not provided enough information to

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

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?= writes: >> We have lots data to insert in that table which have the spgist ind

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

=?utf-8?B?5p2O5rW36b6Z?= 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-cont

[HACKERS] I s this a bug of spgist index in a heavy write condition?

Hi,pgsql-hackers, I'm not sure whether it is a bug of using spgist index or not . OS Version: CentOS release 6.2 (Final) PostgreSQL Version: postgres=# select version(); version -- Pos