Import timed out after 60 seconds

I’m trying to execute a “Bulk upsert via a primary key” on a PostgreSQL and I get a timeout after 60 seconds even if I change Query Timing - query time out params to a higher number.
It is basically a CSV import with about 300 lines.
The column used as PK is not the table’s PK but a indexed column.
Error:
Import timed out after 60 seconds or
ROLLBACK - Client has encountered a connection error and is not queryable
Any idea how to solve this?

I wonder what retool is doing under the hood. Is it using upsert (INSERT INTO table_name(column_list) VALUES(value_list) ON CONFLICT target action;)?

Instead of using “Bulk upsert” query I simply generated a string with INSERT ... ON CONFLICT DO UPDATE. Running this generated query directly against the database it takes about half second for 300 rows.
It may be a space for improvement in the future

1 Like

Thank you for sharing your workaround! It is an odd reaction to using the indexed column in place of the PK.

The data set that is getting uploaded, is that actually an uploaded CSV somehow?

The data set that is getting uploaded, is that actually an uploaded CSV somehow?
I’m using File Picker component to upload the CSV and parse it

I ran into this same issue. Is there a way to dynamically generate the string (based on the results of a query, for example)?