On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka <books@xxxxxxxxxx> wrote: > > > On Thu, 23 Apr 2009, Thomas Kellerer wrote: > >> Out of curiosity I did some tests through JDBC. >> >> Using a single-column (integer) table, re-using a prepared statement took >> about 7 seconds to insert 100000 rows with JDBC's batch interface and a >> batch size of 1000 >> > > As a note for non-JDBC users, the JDBC driver's batch interface allows > executing multiple statements in a single network roundtrip. This is > something you can't get in libpq, so beware of this for comparison's sake. Really? I thought that executing statements like so: select * from a;insert ...;delete; in psql / libpq would execute them all in one trip. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
