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?
From: Joshua D. Drake <jd(at)commandprompt(dot)com>
To: Divakar Singh <dpsmails(at)yahoo(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>; pgsql-performance(at)postgresql(dot)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
In response to
pgsql-performance by date
|Next:||From: Steve Wong||Date: 2010-10-25 18:46:23|
|Subject: MVCC and Implications for (Near) Real-Time Application|
|Previous:||From: Joshua D. Drake||Date: 2010-10-25 18:38:52|
|Subject: Re: Postgres insert performance and storage requirement
compared to Oracle|
pgsql-hackers by date
|Next:||From: Jeff Davis||Date: 2010-10-25 18:44:18|
|Subject: Re: Range Types, discrete and/or continuous|
|Previous:||From: Tom Lane||Date: 2010-10-25 18:41:29|
|Subject: Re: add label to enum syntax |