Reputation
8,834
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 21 47
Newest
 Enlightened
Impact
~428k people reached

Jul
29
reviewed Close SQL Server 2014 vs Amazon Redshift performance
Jul
29
reviewed Close Best Admin Tool for Postgres
Jul
28
revised Simultaneous calls to the same function: how are deadlocks occurring?
added 23 characters in body
Jul
28
reviewed Edit Lock wait timeout exceeded; try restarting transaction in NDB
Jul
28
revised Lock wait timeout exceeded; try restarting transaction in NDB
improved formatting
Jul
28
reviewed No Action Needed Will longer DB transactions make calls to other DB wait?
Jul
28
comment Lock wait timeout exceeded; try restarting transaction in NDB
When promoting your product, please always indicate your affiliation with the company.
Jul
28
reviewed Close sql query for interchanging rows and columns
Jul
28
reviewed Close Having problem with adding more than one DIT
Jul
28
comment How to improve perfomance or Query Execution Time in MySQL?
I think the only way to improve it is serious rethinking and rewriting. One cannot even reasonably figure out what's going on...
Jul
28
reviewed Close Remote connection to oracle database 12c
Jul
28
reviewed Leave Closed Should I use a separate postgres schema for application logins?
Jul
28
reviewed Reopen How to pass the value of PK to FK
Jul
28
reviewed No Action Needed How to find all positions of a string within another string
Jul
28
revised MySql Innodb corruption recovery
added 5 characters in body; edited tags
Jul
27
reviewed Leave Closed How to do superscript in SQL Server 2012 query?
Jul
27
reviewed Leave Closed How to distribute Oracle database
Jul
27
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
@Maddy normally, I would expect plain inserts to be mostly IO bound. There is nothing much to calculate on it... Could you describe the system in a bit more detail? I am after the disks/RAID/whatever, mostly.
Jul
27
awarded  Caucus
Jul
27
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
So you are comparing apples to oranges hardware-wise, right? Nonetheless, you can try parallelizing the batches (using threads, I guess). BTW, may I ask why you don't want to use COPY?