I am working on adding support for PostgreSQL database for our application. In a lot of our use-cases, data is inserted into temporary tables using INSERT INTO statements with bind parameters, and subsequently queries are run by joining to these temp tables. Following is some of the data for these INSERT statements:
Table definition: CREATE TEMPORARY TABLE Table1( auid varchar(15) ) ON COMMIT DELETE ROWS; SQL statement: INSERT INTO Table1 (uidcol) VALUES (:1); Time taken to insert 24428 rows: 10.077 sec Time taken to insert 32512 rows: 16.026 sec Time taken to insert 32512 rows: 15.821 sec Time taken to insert 6107 rows: 1.514 sec I am looking for suggestions to improve the performance of these INSERT statements into temporary tables. Database is located on a Linux VM and the version is "PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-18), 64-bit". The application is running on a windows platform and connecting to the database using psqlODBC driver version 10.03. Please let me know if any additional information is needed. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
