Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B4F3364FF27
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 16 Sep 2008 11:20:06 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 49472-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 16 Sep 2008 11:19:55 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f17.google.com (mail-gx0-f17.google.com
	[209.85.217.17])
	by postgresql.org (Postfix) with ESMTP id 9E4D364FD0A
	for <pgsql-admin@postgresql.org>; Tue, 16 Sep 2008 11:19:54 -0300 (ADT)
Received: by gxk10 with SMTP id 10so25409342gxk.19
	for <pgsql-admin@postgresql.org>; Tue, 16 Sep 2008 07:19:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:mime-version:content-type;
	bh=Yz+PtfiK/c7vJTogEPCQ2gTyzpyHL0E9LxcZq7mHLWw=;
	b=K+sbqWkpvWpSv0ykCsSIMDdC8EjSrpGhqypcgigEa+Ry2FHGHFuRn5SLC/VwDiHmeZ
	uCe3RXTF9z0cZ2TQ998FULOxTKeHtZ7T2Szykeu4hhZ8ueO5MINge/KCQVTW3euxNYqL
	26+RXlCQ99kTGPKQDofMOVhWKtoJe1XavBfTg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:mime-version:content-type;
	b=WhCgKfNSRJ5R4OcFXs2X5fyMt2+iPzIYBW2S0YAqpTkC1xjXobHeC+8i/82WSbWMhr
	U9gsOhFu/b/L57mNgQ3fnzGPtebo7XKKD0Ob29AtfO6vettZX04KsLePDQTqbqBexriI
	RtGZHjwPg8VDDWwbn7ANbvFK7dc3ONOJDL+P8=
Received: by 10.90.73.17 with SMTP id v17mr1617072aga.76.1221574791592;
	Tue, 16 Sep 2008 07:19:51 -0700 (PDT)
Received: by 10.90.52.17 with HTTP; Tue, 16 Sep 2008 07:19:51 -0700 (PDT)
Message-ID: <407fa4640809160719q275e0761pb7c93b3de5a98896@mail.gmail.com>
Date: Tue, 16 Sep 2008 15:19:51 +0100
From: "Michael Nacos" <m.nacos@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pgBee - a Postgresql Bulk Updater in Java
Cc: pgsql-jdbc@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_33982_19361143.1221574791573"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/159
X-Sequence-Number: 30252

------=_Part_33982_19361143.1221574791573
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

"pgBee is a set of Java classes I wrote for automating bulk updates of
Postgresql databases on Linux servers. It requires Java (doh!) and Ant (as a
build/execute front-end), it is cronnable and performs very well, especially
in multi-threaded mode, which takes full advantage of multi-core CPUs in
modern servers."

inspiration for this has come from
http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php and my own
tests...

until pgBee is hosted in pgFoundry, you may find the source code here:
http://freeyourtech.wordpress.com/2008/09/16/pgbee-a-postgresql-bulk-updater-in-java/

comments, suggestions welcome

Michael

------=_Part_33982_19361143.1221574791573
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">&quot;pgBee is a set of Java classes I wrote for automating bulk updates of
Postgresql databases on Linux servers. It requires Java (doh!) and Ant
(as a build/execute front-end), it is cronnable and performs very well,
especially in multi-threaded mode, which takes full advantage of
multi-core CPUs in modern servers.&quot;<br><br>inspiration for this has come from <a title="multi-statement JDBC updates in batch mode" href="http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php">http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php</a> and my own tests...<br>
<br>until pgBee is hosted in pgFoundry, you may find the source code here: <a href="http://freeyourtech.wordpress.com/2008/09/16/pgbee-a-postgresql-bulk-updater-in-java/">http://freeyourtech.wordpress.com/2008/09/16/pgbee-a-postgresql-bulk-updater-in-java/</a><br>
<br>comments, suggestions welcome<br><br>Michael<br></div>

------=_Part_33982_19361143.1221574791573--