jrgemignani commented on issue #1837: URL: https://github.com/apache/age/issues/1837#issuecomment-2099496759
@devcode100 I have not been able to reproduce this and I created 120,000 nodes as shown below, in both the latest and PG16 release 1.5.0. It could be that your install got messed up? ``` psql-16.1-5432-pgsql=# DO $do$ BEGIN FOR i in 1..100000 LOOP PERFORM * FROM cypher('test', $$ CREATE (:Category {name: 'CategoryTest1'}) CREATE (:Category {name: 'CategoryTest2'}) CREATE (:Category2 {name: 'CategoryTest1'}) CREATE (:Category2 {name: 'CategoryTest2'}) $$) AS (n agtype); end LOOP; end $do$; DO psql-16.1-5432-pgsql=# DO $do$ BEGIN FOR i in 1..100000 LOOP PERFORM * FROM cypher('test', $$ CREATE (:Category {name: 'CategoryTest1'}) CREATE (:Category {name: 'CategoryTest2'}) CREATE (:Category2 {name: 'CategoryTest1'}) CREATE (:Category2 {name: 'CategoryTest2'}) $$) AS (n agtype); end LOOP; end $do$; DO psql-16.1-5432-pgsql=# DO $do$ BEGIN FOR i in 1..100000 LOOP PERFORM * FROM cypher('test', $$ CREATE (:Category {name: 'CategoryTest1'}) CREATE (:Category {name: 'CategoryTest2'}) CREATE (:Category2 {name: 'CategoryTest1'}) CREATE (:Category2 {name: 'CategoryTest2'}) $$) AS (n agtype); end LOOP; end $do$; DO psql-16.1-5432-pgsql=# select * from cypher('test', $$ match (u) return count(u) $$) as (result agtype); result --------- 1200000 (1 row) psql-16.1-5432-pgsql=# ``` -- 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: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org