postgresql

Sources https://www.postgresql.org/docs/current/runtime-config-resource.html https://dba.stackexchange.com/questions/64570/postgresql-error-out-of-memory <> SQL Error: 0, SQLState: 53200 out of memory Could not extract ResultSet, nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet https://stackoverflow.com/questions/70158261/postgresql-14-2-out-of-memory-failed-on-request-of-size-24576-in-memory-conte Failed on request of size 24576 in memory context "TupleSort main" https://postgrespro.com/list/thread-id/2437174 SQL Error: 0, SQLState: 53200 ERROR: out of memory Detail: Failed on request of size 152 in memory context "ExecutorState" ERROR: out of memory Detail: Failed on request of size 32800 in memory context "HashBatchContext"....

Sources Inefficient, but does the job: https://dev.to/antjanus/using-postgres-for-loop-to-generate-data-3mm2 DO $FN$ BEGIN FOR counter IN 1..100 LOOP RAISE NOTICE 'Counter: %', counter; EXECUTE $$ INSERT INTO items(name, active) VALUES ('Test item ' || $1, true) RETURNING id $$ USING counter; END LOOP; END; $FN$