пн, 25 мая 2020 г. в 18:25, Justin Pryzby :
> I wonder if/how that fails if you create the index before adding data:
>
> CREATE TABLE test_path(path ltree);
> CREATE INDEX ON test_path USING GIST(path);
> INSERT INTO test_path SELECT * FROM comments.mp_comments;
>
> Does that fail on a particular
On Mon, May 25, 2020 at 04:41:49PM +0300, Victor Yegorov wrote:
> New index to be created:
> CREATE INDEX i_mp_comments_mpath_gist ON comments.mp_comments USING gist
> (mpath);
I wonder if/how that fails if you create the index before adding data:
CREATE TABLE test_path(path ltree);
CREATE INDEX
On Sun, May 24, 2020 at 09:30:15PM +0300, Victor Yegorov wrote:
> 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
>
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
