Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1B27D1337B5D for ; Mon, 25 Oct 2010 16:51:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 12881-06 for ; Mon, 25 Oct 2010 19:51:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id B8F2A1337B4E for ; Mon, 25 Oct 2010 16:51:46 -0300 (ADT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Postgres insert performance and storage requirement compared to Oracle Date: Mon, 25 Oct 2010 12:51:41 -0700 User-Agent: KMail/1.13.2 (Linux/2.6.32-25-generic; KDE/4.4.2; x86_64; ; ) References: <402913.53404.qm@web65405.mail.ac4.yahoo.com> <781874.42830.qm@web65413.mail.ac4.yahoo.com> In-Reply-To: <781874.42830.qm@web65413.mail.ac4.yahoo.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201010251251.41812.ahodgson@simkin.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/412 X-Sequence-Number: 40830 On October 25, 2010 11:36:24 am Divakar Singh wrote: > Above results show good INSERT performance of PG when using SQL procedures. > But performance when I use C++ lib is very bad. I did that test some time > back so I do not have data for that right now. Wrap it in a transaction.