problem with custom Gist for custom type

Started by Grzegorz Jaskiewiczabout 20 years ago6 messages
#1Grzegorz Jaskiewicz
gj@pointblue.com.pl

Hi there folks

I created custom type, and attempt to create gist indexing for it, to
make search wind quick.
on select from * where something << 'something'; I get:

WARNING: problem in alloc set GiST temporary context: detected write
past chunk end in block 0x843e6e0, chunk 0x843e994

Can someone tell me please, what might be the cause?

Thanks

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Grzegorz Jaskiewicz (#1)
Re: problem with custom Gist for custom type

Grzegorz Jaskiewicz <gj@pointblue.com.pl> writes:

I created custom type, and attempt to create gist indexing for it, to
make search wind quick.
on select from * where something << 'something'; I get:

WARNING: problem in alloc set GiST temporary context: detected write
past chunk end in block 0x843e6e0, chunk 0x843e994

Can someone tell me please, what might be the cause?

Looks like you're scribbling on memory that doesn't belong to you.
Check for miscomputed palloc request sizes, etc.

regards, tom lane

#3Grzegorz Piotr Jaskiewicz
gj@pointblue.com.pl
In reply to: Tom Lane (#2)
Re: problem with custom Gist for custom type

On Wednesday 26 October 2005 17:48, Tom Lane wrote:

Looks like you're scribbling on memory that doesn't belong to you.
Check for miscomputed palloc request sizes, etc.

Thanks very much for the tip. I thogut perhaps I am not filling out some parts
of structures, or something.
Can I use valgrind to find out the root of problem. If so, how should I invoke
it with postgres. Postgres it self was configured with:

./configure --prefix=/usr/local/postgres --with-python --enable-cassert
--with-openssl --with-gnu-ld --enable-integer-datetimes --enable-debug

Thanks.

--
GJ

Binary system, you're either 1 or 0...
dead or alive ;)

#4Oleg Bartunov
oleg@sai.msu.su
In reply to: Tom Lane (#2)
Re: problem with custom Gist for custom type

btw, if you could read russian, we have GiST programming tutorial
http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html

Oleg
On Wed, 26 Oct 2005, Tom Lane wrote:

Grzegorz Jaskiewicz <gj@pointblue.com.pl> writes:

I created custom type, and attempt to create gist indexing for it, to
make search wind quick.
on select from * where something << 'something'; I get:

WARNING: problem in alloc set GiST temporary context: detected write
past chunk end in block 0x843e6e0, chunk 0x843e994

Can someone tell me please, what might be the cause?

Looks like you're scribbling on memory that doesn't belong to you.
Check for miscomputed palloc request sizes, etc.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#5Grzegorz Piotr Jaskiewicz
gj@pointblue.com.pl
In reply to: Oleg Bartunov (#4)
Re: problem with custom Gist for custom type

On Wednesday 26 October 2005 18:34, Oleg Bartunov wrote:

btw, if you could read russian, we have GiST programming tutorial
http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html

I did try, but last time I did Russian lessons was around 10 years ago, so ...
babel fish could help btw, but I would kindly ask for translating this tut.
Especially if you can elaborate on picksplit method more, it would be great.

--
GJ

Binary system, you're either 1 or 0...
dead or alive ;)

#6Grzegorz Piotr Jaskiewicz
gj@pointblue.com.pl
In reply to: Grzegorz Piotr Jaskiewicz (#3)
Re: problem with custom Gist for custom type

Ok, I got it, google is my friend ;)
...

Can I use valgrind to find out the root of problem. If so, how should I
invoke it with postgres. Postgres it self was configured with:

...

--
GJ

Binary system, you're either 1 or 0...
dead or alive ;)