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=nW9GulXOPJ+i8KWvqiQrDWqYfBaOB0hDrg2VgofVEb4NZqmPw4/2ohNqlRqp4wuM35IW6A4mzn3nu7HOwokUjzPZzDNdCqXQTqAemxpqh17F7NNeGHCYM9dsYV7OkrsCjuoEEHdNOGQjXuZKoPiznk7xcOZKU4K/raMYQadg+9E=;
Message-ID: <772167.16310.qm@web65409.mail.ac4.yahoo.com>
References: <402913.53404.qm@web65405.mail.ac4.yahoo.com>
	<1288030833.8930.30.camel@jd-desktop>
Date: Mon, 25 Oct 2010 11:31:22 -0700 (PDT)
From: Divakar Singh <dpsmails@yahoo.com>
Subject: Re: Postgres insert performance and storage requirement compared to
	Oracle
To: jd@commandprompt.com
Cc: pgsql-performance@postgresql.org
In-Reply-To: <1288030833.8930.30.camel@jd-desktop>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1830670785-1288031482=:16310"

--0-1830670785-1288031482=:16310
Content-Type: text/plain; charset=us-ascii


> 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.

-- Did you test?

Yes. the performance was comparable when using SQL procedure. However, When I 
used libpq, PostgreSQL performed very bad. There was some difference in 
environment also between these 2 tests, but I am assuming libpq vs SQL was the 
real cause. Or it was something else?
 
> 
> 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.

 -- What was your table structure?

Some 10-12 columns ( like 2 timestamp, 4 int and 4 varchar), with 5 indexes on 
varchar and int fields including 1 implicit index coz of PK. 


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


--0-1830670785-1288031482=:16310
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"><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;"><br>&gt; My questions/scenarios are:<br>&gt; <br>&gt; 1. How does PostgreSQL perform when inserting data into an indexed<br>&gt; (type: btree) <br>&gt; table? Is it true that as you add the indexes on a table, the<br>&gt; performance <br>&gt; deteriorates significantly whereas Oracle does not show that much<br>&gt; performance <br>&gt; decrease. I have tried almost all postgreSQL performance tips<br>&gt; available. I want <br>&gt; to have very good "insert" performance (with indexes), "select"<br>&gt; performance is <br>&gt; not that important at this point of time.<br><br>-- Did you test?<br><br>Yes. the performance was comparable when using SQL procedure. However, When I used libpq, PostgreSQL performed very bad. There was some
 difference in environment also between these 2 tests, but I am assuming libpq vs SQL was the real cause. Or it was something else?<br>&nbsp;<br>&gt; <br>&gt; 2. What are the average storage requirements of postgres compared to<br>&gt; Oracle? I <br>&gt; inserted upto 1 million records. The storage requirement of postgreSQL<br>&gt; is almost <br>&gt; double than that of Oracle.<br><br>&nbsp;-- What was your table structure?<br><br>Some 10-12 columns ( like 2 timestamp, 4 int and 4 varchar), with 5 indexes on varchar and int fields including 1 implicit index coz of PK. <br><br><br>Joshua D. Drake<br><br><br>-- <br>PostgreSQL.org Major Contributor<br>Command Prompt, Inc: <a href="http://www.commandprompt.com/" target="_blank">http://www.commandprompt.com/</a> - 509.416.6579<br>Consulting, Training, Support, Custom Development, Engineering<br><a href="http://twitter.com/cmdpromptinc" target="_blank">http://twitter.com/cmdpromptinc</a> | <a
 href="http://identi.ca/commandprompt" target="_blank">http://identi.ca/commandprompt</a><br><br></div>
</div><br>

      </body></html>
--0-1830670785-1288031482=:16310--