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?
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.sqlon thepsqlconsole.What I expected
All
INSERT INTOstatements are executed and theemployeetable has 1,000 records.What I got
psqlreturns an error with the following message:The
employeetable only has 657 records.After the error, I couldn't insert any records into the table.
Question
How can I insert more than 1000 records into a table on Postgres WASM?