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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
