Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 167C79FBDD5 for ; Fri, 16 Mar 2007 10:52:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 61603-02-6 for ; Fri, 16 Mar 2007 10:52:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 9AD519FBDFF for ; Fri, 16 Mar 2007 10:52:34 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so261842nfb for ; Fri, 16 Mar 2007 06:52:33 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=da+4CjdQ+tMZv7t9lHR3Fya3oHyADjixbgJZkvcBprMnApgHOJhf7590ZFz9IEv6/hRNay8PZ44ThMJOHVaCw3ICKM5UAg/n0ZaAmfL6eMmXCPiqUJt2Y7dzvChlUuOfZTywYpQup22BAsa4xiXjUS9PZNhKZyC99gZZf87vw6k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QNxpYrFpHyH8P3CquHkHLt1Saap0s6W1fjGMo1E93Z66B2obkt2XUXyA/GBBDEhlpKiTk1SKdfy4qLtso0AkRkX8VnAZem/i4yRSLfZTymJiWbTLGaUExUYhEogUMlAB8zRq5HoAgPstYZwcK09/KJZj02IJ/pBcNaiGU5tWW+I= Received: by 10.78.81.20 with SMTP id e20mr996774hub.1174053152737; Fri, 16 Mar 2007 06:52:32 -0700 (PDT) Received: by 10.78.35.18 with HTTP; Fri, 16 Mar 2007 06:52:32 -0700 (PDT) Message-ID: Date: Fri, 16 Mar 2007 08:52:32 -0500 From: "Merlin Moncure" To: femski Subject: Re: Postgres batch write very slow - what to do Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9452092.post@talk.nabble.com> <45F685B7.5040001@enterprisedb.com> <9453712.post@talk.nabble.com> <9473692.post@talk.nabble.com> <9486986.post@talk.nabble.com> <9492938.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/255 X-Sequence-Number: 23660 On 3/16/07, Merlin Moncure wrote: > Be careful...you are just testing one very specific thing and it its > extremely possible that the Oracle JDBC batch insert is more optimized > than PostgreSQL's. On my little pentium 4 workstation, by inserting > 10 rows per insert: > insert values ([...]), ([...]), [8 more rows]; small correction here, I actually went and looked at the JDBC api and realized 'addBatch' means to run multiple stmts at once, not batch inserting. femski, your best bet is to lobby the JDBC folks to build support for 'copy' into the driver for faster bulk loads (or help out in that regard). merlin