Performance of INSERT into temporary tables using psqlODBC driver

From: padusuma <venkata(dot)adusumalli(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance of INSERT into temporary tables using psqlODBC driver
Date: 2018-09-07 17:04:02
Message-ID: 1536339842382-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Molgaard 2018-09-07 18:03:17 Re: Multi-second pauses blocking even trivial activity
Previous Message James Coleman 2018-09-07 16:17:25 Partial index plan/cardinality costing