| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Divakar Singh <dpsmails(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres insert performance and storage requirement compared to Oracle |
| Date: | 2010-10-25 18:20:33 |
| Message-ID: | 1288030833.8930.30.camel@jd-desktop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-10-25 18:26:27 | Re: bug in explain - core dump |
| Previous Message | Divakar Singh | 2010-10-25 18:12:40 | Postgres insert performance and storage requirement compared to Oracle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | André Volpato | 2010-10-25 18:21:34 | AIX slow buffer reads |
| Previous Message | Divakar Singh | 2010-10-25 18:12:40 | Postgres insert performance and storage requirement compared to Oracle |