Skip site navigation (1) Skip section navigation (2)

Re: Postgres insert performance and storage requirement compared to Oracle

From: Divakar Singh <dpsmails(at)yahoo(dot)com>
To: jd(at)commandprompt(dot)com
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Date: 2010-10-25 18:42:48
Message-ID: 415787.11817.qm@web65404.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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(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 WongDate: 2010-10-25 18:46:23
Subject: MVCC and Implications for (Near) Real-Time Application
Previous:From: Joshua D. DrakeDate: 2010-10-25 18:38:52
Subject: Re: Postgres insert performance and storage requirement compared to Oracle

pgsql-hackers by date

Next:From: Jeff DavisDate: 2010-10-25 18:44:18
Subject: Re: Range Types, discrete and/or continuous
Previous:From: Tom LaneDate: 2010-10-25 18:41:29
Subject: Re: add label to enum syntax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group