Failure to create GiST on ltree column

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Failure to create GiST on ltree column
Дата
Msg-id CAGnEboi=kL2g9xG-McOEZEG25J5aTPYZ5=_A-tcg-8g=TszJ4Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Failure to create GiST on ltree column  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Greetings.

I am getting random failures in `CREATE INDEX USING gist` over ltree column while performing pg_restore.
I get either
    ERROR:  stack depth limit exceeded
or
    ERROR:  failed to add item to index page

Thing is — if I retry index creation manually, I get it successfully built in ~50% of the cases.

I would like to find out what's the real cause here, but I am not sure how to do it.
If anybody could provide some guidance, I am open to investigate this case.

I'm on PostgreSQL 11.8 (Debian 11.8-1.pgdg90+1), debugging symbols installed.

--
Victor Yegorov

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Parallel Seq Scan vs kernel read ahead
Следующее
От: David Rowley
Дата:
Сообщение: Re: [PATCH] Keeps tracking the uniqueness with UniqueKey