From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | <mike(at)mwcs(dot)mb(dot)ca>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | RE: JDBC Performance |
Date: | 2001-08-07 16:56:38 |
Message-ID: | 006d01c11f61$edbdc410$8201a8c0@inspiron |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Doesn't sound normal! Can you post the schema for the table you are
updating
pg_dump -s -t tablename dbname
One thing you can try if you are doing bulk updates is to drop the index
before the update, and create it again afterwards
Dave
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of mike(at)mwcs(dot)mb(dot)ca
Sent: July 31, 2001 4:01 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] JDBC Performance
I am having some performance problems with postgresql and JDBC when it
comes to updates. If I try and update a record it seems to be taking
1.7 seconds for 100 records or 14 seconds for 500 records. An insert is
only taking between 3-5 ms/record. Performance on the updates continue
to decrease until I vacuum analyze the database again. Is this normal?
Mike
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-08-07 17:12:04 | RE: BIGINT vs Java's long |
Previous Message | Rene Pijlman | 2001-08-07 16:54:13 | Re: cast in JDBC update |