Hi
I understand that you are facing an issue with execution time. The following information might be of good help to you.
Inserting data into a PostgreSQL data row by row can be a slow process, especially if you are dealing with a large amount of data.
One way to improve the performance is to use the COPY command instead of INSERT statements.
Here is an example of how you could use the COPY command in MATLAB.
- Create a CSV file with your data.
- Use the COPY command to load the data into the database.
exec(conn, ‘COPY mytable FROM ‘/path to myData.csv’ WITH (FORMAT CSV);’
You can find more information about COPY command in PostgreSQL here :
