Subject: Re: Postgres insert performance and storage requirement
	compared to Oracle
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Divakar Singh <dpsmails@yahoo.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <402913.53404.qm@web65405.mail.ac4.yahoo.com>
References: <402913.53404.qm@web65405.mail.ac4.yahoo.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Mon, 25 Oct 2010 11:20:33 -0700
Message-ID: <1288030833.8930.30.camel@jd-desktop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Mon, 2010-10-25 at 11:12 -0700, Divakar Singh wrote:

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

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

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