creating gist index on ltree column failed

From: jian xu <jamesxu(at)outlook(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: creating gist index on ltree column failed
Date: 2020-09-23 13:31:27
Message-ID: MN2PR05MB68321416773DB46AFCAA323EA1380@MN2PR05MB6832.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I tried to create gist index on a ltree column, first I got error
=====
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth" (currently 32768kB), after ensuring the platform's stack depth limit is adequate.
=====
I increased system memory size with "ulimit -S -s 131072", then run "set max_stack_depth = '64MB';"
this time I got some other errors:
"failed to add item to index page" or "no unpinned buffers available"

sometimes if I rerun it, or run vacuum on the table first, the creating index runs for ever until all the system memory was eaten up, then server was hang, I had to reboot the server.
one thing I notice is, there are some rows with many levels(more than 1k levels) in the ltree, if I delete those rows, creating gist index works

is it a bug in the gist index? does anyone know how to workaround this problem?

thank you

James

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-09-23 14:37:17 Re: creating gist index on ltree column failed
Previous Message Hannah Huang 2020-09-23 08:00:16 Re: Cannot allocate memory