JavaScript heap out of memory error when exporting large schemas

[Dacjan]

When using exportSchema with a large database schema (in my case 294 tables), the process fails with a JavaScript heap out of memory error. This issue occurs specifically with larger schemas, while smaller schemas work as expected.

Current workaround:
Increasing the Node.js heap size limit using --max-old-space-size=8192 resolves the issue.

This issue suggests that the schema export process might need optimization for handling large schemas more efficiently.

[benjie]

My instincts tell me this is an issue in this function:

crystal/utils/graphile-export/src/optimize/index.ts

Line 41 in dc0d446

export const optimize = (inAst: t.File, runs = 1): t.File => {

If you replace that function with:

export const optimize = (inAst: t.File, runs = 1): t.File => {
  return inAst;
}

does the issue go away?

[Dacjan]

It seems your instincts were correct - the issue does indeed go away with that change