ERROR: MemoryContextAlloc: invalid request size (maybe bug in gist index)

Started by Nikolay Kimover 22 years ago3 messages
#1Nikolay Kim
fafhrd@datacom.kz
1 attachment(s)

hi,

i use _int contrib module and gist index
here sample

Attachments:

t1.sql.gzapplication/x-gzip; name=t1.sql.gzDownload
#2Teodor Sigaev
teodor@sigaev.ru
In reply to: Nikolay Kim (#1)
Re: ERROR: MemoryContextAlloc: invalid request size (maybe

Try
create index data_idx on testkw using gist(data gist__intbig_ops);

Default class gist__int_ops is usable for small arrays (with small number of
unique elements of all arrays)

Nikolay Kim wrote:

hi,

i use _int contrib module and gist index
here sample

------------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Teodor Sigaev E-mail: teodor@sigaev.ru

#3Nikolay Kim
fafhrd@datacom.kz
In reply to: Teodor Sigaev (#2)
Re: ERROR: MemoryContextAlloc: invalid request size

thanks!

error is gone.

Show quoted text

On Пнд, 2003-07-14 at 20:36, Teodor Sigaev wrote:

Try
create index data_idx on testkw using gist(data gist__intbig_ops);

Default class gist__int_ops is usable for small arrays (with small number of
unique elements of all arrays)

Nikolay Kim wrote:

hi,

i use _int contrib module and gist index
here sample

------------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org