Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0C7631337B4B for ; Mon, 25 Oct 2010 15:49:38 -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 95431-03 for ; Mon, 25 Oct 2010 18:49:31 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm10-vm1.bullet.mail.ac4.yahoo.com (nm10-vm1.bullet.mail.ac4.yahoo.com [98.139.53.195]) by mail.postgresql.org (Postfix) with SMTP id 2FE1A1337999 for ; Mon, 25 Oct 2010 15:49:30 -0300 (ADT) Received: from [98.139.52.192] by nm10.bullet.mail.ac4.yahoo.com with NNFMP; 25 Oct 2010 18:49:29 -0000 Received: from [98.139.52.160] by tm5.bullet.mail.ac4.yahoo.com with NNFMP; 25 Oct 2010 18:49:29 -0000 Received: from [127.0.0.1] by omp1043.mail.ac4.yahoo.com with NNFMP; 25 Oct 2010 18:49:29 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 890136.26824.bm@omp1043.mail.ac4.yahoo.com Received: (qmail 13048 invoked by uid 60001); 25 Oct 2010 18:42:48 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1288032168; bh=N1mpOmLAqbCvooKNwuriiDaFJaAqW4dJb2V5J0sCq2c=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=BDRpvRHSNw9E/UMLEjr9GEWDvzvz9ovJUyey1XSiIrbHUndGrMXwlSRDEkltX932jCVggmaZNB57FhfIIxelxmHrigW7Sg9MGXviK7DeCqWOXKNddXtDrjT0j4KLPo1SXDofWKxkbG3VuLysMM5JrR7SOIYGArTJJKmEui4hf3U= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=1XrrhYdZQhiBr+rJGOkZCqiZnRgGms4ETggRfEJaqKsC9fjHKWlcN3B8dsz6ACTwGq2DG6/vZmuxTljsiPjqaOHYDBpgfC/+mzMeUYpktXBgvzgJArDuEi8ln9vckjQ91QfRpfVrompOr8Oi1njJjlIgy76OhW8ophjx6/foAyU=; Message-ID: <415787.11817.qm@web65404.mail.ac4.yahoo.com> X-YMail-OSG: Qh6eU24VM1mBzKA5zgLjEsFS_edETVo0tpmTGnfH7fyKtqx A8kxRpjaZJEHY.OTRFJbAFekBfNyl45egIgwGr_p6MoRaChnIz3AOomoUBut xTy9cwdOWBi3de.3dXOuSd61Q2HnYE2Yw9KCePDuC6aYpipbVvBX0_m2sz_F 8W91DTnR4fUbn952sIANY4Dv.bAY0MR8S549qzuUZa3lZE7wGmaFhSBcG0HK zrg4yaz6mwbwmRJZzM3VBhhmt5f75abf0TYk69hOzj5ubuRgE1K_JVziuw.4 NyvuUD_cvnWs9tODOCJZmVscl9A2tVAMI6PKeZ8Qn6him8IbIYCMd1r0j8W2 y2Ft0kEw- Received: from [194.237.142.6] by web65404.mail.ac4.yahoo.com via HTTP; Mon, 25 Oct 2010 11:42:48 PDT X-Mailer: YahooMailRC/504.5 YahooMailWebService/0.8.107.284920 References: <402913.53404.qm@web65405.mail.ac4.yahoo.com> <781874.42830.qm@web65413.mail.ac4.yahoo.com> <1288031932.8930.32.camel@jd-desktop> Date: Mon, 25 Oct 2010 11:42:48 -0700 (PDT) From: Divakar Singh Subject: Re: Postgres insert performance and storage requirement compared to Oracle To: jd@commandprompt.com Cc: Scott Marlowe , pgsql-performance@postgresql.org In-Reply-To: <1288031932.8930.32.camel@jd-desktop> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2099120241-1288032168=:11817" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/405 X-Sequence-Number: 40823 --0-2099120241-1288032168=:11817 Content-Type: text/plain; charset=us-ascii Hi Joshua, I have been only using libpq. Is libpqXX better than the other? Is there any notable facility in libpqxx which could aid in fast inserts or better performance in general? Best Regards, Divakar ________________________________ From: Joshua D. Drake To: Divakar Singh Cc: Scott Marlowe ; pgsql-performance@postgresql.org Sent: Tue, October 26, 2010 12:08:52 AM Subject: Re: [PERFORM] Postgres insert performance and storage requirement compared to Oracle On Mon, 2010-10-25 at 11:36 -0700, Divakar Singh wrote: > > 68 Rows inserted: 100,000 > 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. This is interesting, are you using libpq or libpqXX? Joshua D. Drake > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --0-2099120241-1288032168=:11817 Content-Type: text/html; charset=us-ascii
Hi Joshua,
I have been only using libpq.
Is libpqXX better than the other?
Is there any notable facility in libpqxx which could aid in fast inserts or better performance in general?
 
Best Regards,
Divakar


From: Joshua D. Drake <jd@commandprompt.com>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-performance@postgresql.org
Sent: Tue, October 26, 2010 12:08:52 AM
Subject: Re: [PERFORM] Postgres insert performance and storage requirement compared to Oracle

On Mon, 2010-10-25 at 11:36 -0700, Divakar Singh wrote:
> 
> 68 Rows inserted: 100,000
> 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.

This is interesting, are you using libpq or libpqXX?

Joshua D. Drake


>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

--0-2099120241-1288032168=:11817--