jrgemignani commented on issue #2046:
URL: https://github.com/apache/age/issues/2046#issuecomment-2294205191
@lyp-bobi That was one use of memory. I found the other and now I can build
the index. This was from your commands above -
```
psql-16.2-5432-psql=# drop extension age cascade; create extension age; load
'age'; set search_path TO ag_catalog;
ERROR: extension "age" does not exist
CREATE EXTENSION
LOAD
SET
psql-16.2-5432-psql=# CREATE TABLE test(num agtype);
CREATE TABLE
psql-16.2-5432-psql=# INSERT INTO test SELECT ('{"id": "'||a||'"}')::agtype
FROM generate_series(1,100000000) a;
INSERT 0 100000000
psql-16.2-5432-psql=# CREATE INDEX ON test USING btree(num);
CREATE INDEX
psql-16.2-5432-psql=#
```
Now I need to work on a PR to get this fix in.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
