This repository was archived by the owner on Sep 19, 2024. It is now read-only.
This repository was archived by the owner on Sep 19, 2024. It is now read-only.
Can't insert more than 657 records into a table #45
Description
What I want to do
I want to insert more than 1000 records into a table to see the performance of Postgres WASM.
What I did
I have a file to load data to a table like https://gist.github.com/satob/421f19ed438a9abe56b7139022df44d2 .
I have uploaded the file with [Transfer Files] and run \i /mnt/test.sql on the psql console.
What I expected
All INSERT INTO statements are executed and the employee table has 1,000 records.
What I got
psql returns an error with the following message:
postgres=# \i /mnt/test.sql CREATE TABLE INSERT 0 1 (snip) INSERT 0 1 psql:/mnt/test.sql:665: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. psql:/mnt/test.sql:665: fatal: connection to server was lost # The employee table only has 657 records.
postgres=# select count(*) from employee; count ------- 657 (1 row) After the error, I couldn't insert any records into the table.
# psql -U postgres psql (14.5) Type "help" for help. postgres=# insert into employee values (998, 'Guy Zimmerman'); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !?> Question
How can I insert more than 1000 records into a table on Postgres WASM?