DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=cSqimL7tf8XiRgylFfxdnq919YfDwmJcNEXFsJA/3tHmRrq9sGptuIQXofvP7p9GEWeyyd7WC8ganZPJzIEbuBuPpbw1vbIEBP/wbtE33qz49+dKq91mGz1R+x/WxFIO+xkGeLR6gmClsXBjvzAwRZPcg+qMZaqmBZ8imehO9Tc=;
Message-ID: <402913.53404.qm@web65405.mail.ac4.yahoo.com>
Date: Mon, 25 Oct 2010 11:12:40 -0700 (PDT)
From: Divakar Singh <dpsmails@yahoo.com>
Subject: Postgres insert performance and storage requirement compared to
 Oracle
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-314445254-1288030360=:53404"

--0-314445254-1288030360=:53404
Content-Type: text/plain; charset=us-ascii

Hello Experts,
My application uses Oracle DB, and makes use of OCI interface.
I have been able to develop similar interface using postgreSQL library.
However, I have done some tests but results for PostgreSQL have not been 
encouraging for a few of them.

My questions/scenarios are:

1. How does PostgreSQL perform when inserting data into an indexed (type: btree) 
table? Is it true that as you add the indexes on a table, the performance 
deteriorates significantly whereas Oracle does not show that much performance 
decrease. I have tried almost all postgreSQL performance tips available. I want 
to have very good "insert" performance (with indexes), "select" performance is 
not that important at this point of time.

2. What are the average storage requirements of postgres compared to Oracle? I 
inserted upto 1 million records. The storage requirement of postgreSQL is almost 
double than that of Oracle.

Thanks in anticipation.


--0-314445254-1288030360=:53404
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:#000000;">Hello Experts,<br>My application uses Oracle DB, and makes use of OCI interface.<br>I have been able to develop similar interface using postgreSQL library.<br>However, I have done some tests but results for PostgreSQL have not been encouraging for a few of them.<br><br>My questions/scenarios are:<br><br>1. How does PostgreSQL perform when inserting data into an indexed (type: btree) table? Is it true that as you add the indexes on a table, the performance deteriorates significantly whereas Oracle does not show that much performance decrease. I have tried almost all postgreSQL performance tips available. I want to have very good "insert" performance (with indexes), "select" performance is not that important at this point of time.<br><br>2. What are the average storage requirements of postgres
 compared to Oracle? I inserted upto 1 million records. The storage requirement of postgreSQL is almost double than that of Oracle.<br><br>Thanks in anticipation.</div><br>

      </body></html>
--0-314445254-1288030360=:53404--