Howdy!
I'm converting an application to be using postgresql instead of oracle.
There seems to be only one issue left, batch inserts in postgresql seem
significant slower than in oracle. I have about 200 batch jobs, each
consisting of about 14 000 inserts. Each job takes 1.3 seconds in
postgresql
conn.setAutoCommit(false);
pst = conn.prepareStatement(INSERT INTO tmp (...) VALUES (?,?));
for (int i = 0; i len; i++) {
pst.setInt(0, 2);
pst.setString(1, xxx);
pst.addBatch();
}
pst.executeBatch();
conn.commit();
This snip takes 1.3 secs in postgresql. How can I lower that?
You're
On 5/2/05, Tim Terlegård [EMAIL PROTECTED] wrote:
Howdy!
I'm converting an application to be using postgresql instead of oracle.
There seems to be only one issue left, batch inserts in postgresql seem
significant slower than in oracle. I have about 200 batch jobs, each
consisting of about
On 5/2/05, Tim Terlegård [EMAIL PROTECTED] wrote:
Howdy!
I'm converting an application to be using postgresql instead of oracle.
There seems to be only one issue left, batch inserts in postgresql seem
significant slower than in oracle. I have about 200 batch jobs, each
consisting
We ran into the need to use COPY, but our application is also in Java.
We wrote a JNI bridge to a C++ routine that uses the libpq library to do
the COPY. The coding is a little bit weird, but not too complicated -
the biggest pain in the neck is probably getting it into your build
system.
Here's
Actually, the earliest paper that solves the distinct_n estimation
problem in 1 pass is the following:
Estimating simple functions on the union of data streams
by Gibbons and Tirthapura, SPAA 2001.
http://home.eng.iastate.edu/~snt/research/streaming.pdf
The above paper addresses
[EMAIL PROTECTED] (Christopher Petrilli) writes:
On 5/2/05, Tim Terlegård [EMAIL PROTECTED] wrote:
Howdy!
I'm converting an application to be using postgresql instead of
oracle. There seems to be only one issue left, batch inserts in
postgresql seem significant slower than in oracle. I