franchise icon indicating copy to clipboard operation
franchise copied to clipboard

Too many rows to serialize on postgres

Open ntldrake opened this issue 6 years ago • 1 comments

I think the initialization is struggling with the amount of data in my database and it's timing out. Can you add an option to not serialize?

Error:

received: {"action":"exec","sql":"SELECT table_schema, table_name, column_name\n            FROM information_schema.columns \n            WHERE table_schema not in ('pg_catalog', 'information_schema', 'pg_internal')","id":3}
Error: Too many result rows to serialize: Try using a LIMIT statement.

ntldrake avatar Sep 22 '17 20:09 ntldrake

I'm getting this error too. In my case there are a lot of inherited tables. Being able to supply a table name filter before running this check would be good. Or just a plain limit with pagination to start could work.

c0bra avatar Oct 03 '17 13:10 c0bra