On Fri, 15 Oct 2004 11:54:44 -0500, richard_d_levine(at)raytheon(dot)com
> My basic question to the community is "is PostgreSQL approximately as fast
> as Oracle?"
My personal experience comparing PG to Oracle is across platforms,
Oracle on Sun/Solaris (2.7, quad-proc R440) and PG on Intel/Linux (2.6
kernel, dual P3/1GHz). When both were tuned for the specific app I
saw a 45% speedup after switching to PG. This was with a customized
CRM and System Monitoring application serving ~40,000 trouble tickets
and monitoring 5,000 metric datapoints every 5-30 minutes.
The hardware was definitely not comparable (the Intel boxes have more
horsepower and faster disks), but dollar for dollar, including support
costs, PG is the winner by a BIG margin. YMMV, of course, and my
results are apparently above average.
Another big plus I found was that PG is much easier to admin as long
as you turn on pg_autovacuum.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-10-15 19:53:28|
|Subject: Re: Tuning shared_buffers with ipcs ? |
|Previous:||From: Josh Berkus||Date: 2004-10-15 19:44:52|
|Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...|