Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Using a COPY...FROM through JDBC?

From: Steve Wampler <swampler(at)noao(dot)edu>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Postgres-JDBC <pgsql-jdbc(at)postgresql(dot)org>,Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] Using a COPY...FROM through JDBC?
Date: 2004-06-07 17:59:25
Message-ID: 1086631165.25790.26.camel@weaver.tuc.noao.edu (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-performance
On Mon, 2004-06-07 at 10:40, Steve Wampler wrote:

> Thanks Kris - that patch worked beautifully and bumped the
> insert rate from ~1000 entries/second to ~9000 e/s in my
> test code.

As a followup - that 9000 e/s becomes ~21,000 e/s if I don't
have the java code also dump the message to standard output!

-- 
Steve Wampler -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

In response to

pgsql-performance by date

Next:From: Dan LangilleDate: 2004-06-07 19:45:42
Subject: seq scan woes
Previous:From: Steve WamplerDate: 2004-06-07 17:40:56
Subject: Re: [PERFORM] Using a COPY...FROM through JDBC?

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-06-07 21:38:01
Subject: Re: [PERFORM] Using a COPY...FROM through JDBC?
Previous:From: Steve WamplerDate: 2004-06-07 17:40:56
Subject: Re: [PERFORM] Using a COPY...FROM through JDBC?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group