| 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: | Whole Thread | Raw Message | 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
| 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 |