| From: | elwood(at)agouros(dot)de (Konstantinos Agouros) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Is Oracle really so much faster |
| Date: | 2001-02-01 18:47:33 |
| Message-ID: | elwood.981053060@news.agouros.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
today I did my first test with Oracle instead of PG (I had to really the boss
wanted it \:).
I have some perl-scripts using DBI, that insert a large amount of data, reduce
it and then create some report.
When I insert I do something like $dbh->{'AutoCommit'} = 0 and every 100,000
entries or so I do a commit. I use DBI's prepard_statements, although if I re-
member the manpage correctly that does not have too much impact on PG?
However the result was (running on 64bit Sol 7, E250/1Gig RAM) that Oracle was
roughly twice as fast. Is this real or might there be stuff I could do, to im-
prove postgres performance?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Dunn | 2001-02-01 19:01:35 | Re: Order of Rules |
| Previous Message | Bruce Momjian | 2001-02-01 18:44:28 | Re: Re: Disk acces |