This repository was archived by the owner on Sep 19, 2024. It is now read-only.
- Notifications
You must be signed in to change notification settings - Fork78
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
Open
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 likehttps://gist.github.com/satob/421f19ed438a9abe56b7139022df44d2 .
I have uploaded the file with [Transfer Files] and run\i /mnt/test.sql on thepsql console.
What I expected
AllINSERT INTO statements are executed and theemployee table has 1,000 records.
What I got
psql returns an error with the following message:
postgres=# \i /mnt/test.sqlCREATE TABLEINSERT 0 1 (snip)INSERT 0 1psql:/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#Theemployee 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 postgrespsql (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?
Metadata
Metadata
Assignees
Labels
No labels