at 2013-01-12 02:21, Tom Lane wrote:
=?gb2312?B?wO66o8H6?= hailong...@qunar.commailto:hailong...@qunar.com
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
=?gb2312?B?wO66o8H6?= hailong...@qunar.com 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
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
=?gb2312?B?wO66o8H6?= hailong...@qunar.com 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
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
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
--
=?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.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
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...@qunar.com writes:
We have lots data to insert in that table which