I have to update a certain column of a table at many rows. (order of
For now, I am using a prepare statement and executing the queries like:
query = "UPDATE mytable SET myvar = $1 WHERE myvar2=$2"
db.execute(query, (var, var1)) #db is my connection object
But, I still feel like I can make it faster by using db.executemany()
method. The thing is I am not able to get the syntax of it.
Can anyone please guide me as to how do I do batch updates in the
fastest possible manner? Also, will executemany() really be faster? If
so, how does that result in faster batch updates?
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-08-29 15:03:15|
|Subject: Re: question about logging_collector|
|Previous:||From: Bartosz Dmytrak||Date: 2012-08-29 11:47:25|
|Subject: Re: Problem with CREATE TRIGGER|