From: Divakar Singh <dpsmails@yahoo.com>
To: jd@commandprompt.com
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Date: Mon, 25 Oct 2010 11:42:48 -0700 (PDT)
Message-ID: <415787.11817.qm@web65404.mail.ac4.yahoo.com> (raw)
In-Reply-To: <1288031932.8930.32.camel@jd-desktop>
References: <402913.53404.qm@web65405.mail.ac4.yahoo.com>
<AANLkTinB1yN0u61EGceCXq6Tjp+RuQ0-JDRp5usZAfWp@mail.gmail.com>
<781874.42830.qm@web65413.mail.ac4.yahoo.com>
<1288031932.8930.32.camel@jd-desktop>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dpsmails@yahoo.com, jd@commandprompt.com, scott.marlowe@gmail.com
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
In-Reply-To: <415787.11817.qm@web65404.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox