Hi,
I am looking for some recent and hopefully genuine comparisons between
Oracle and PostgreSQL regarding their performance in large scale
applications. Tests from real world applications would be preferable
but not required. Also differentiations in different areas (i.e.
different data types, qu
On Sun, Dec 21, 2008 at 1:17 AM, Victor Nawothnig
wrote:
> Hi,
>
> I am looking for some recent and hopefully genuine comparisons between
> Oracle and PostgreSQL regarding their performance in large scale
> applications. Tests from real world applications would be preferable
> but not required. Al
On Dec 20, 2008, at 5:33 PM, Gregory Stark wrote:
"Mark Wong" writes:
To recap, dbt2 is a fair-use derivative of the TPC-C benchmark. We
are using a 1000 warehouse database, which amounts to about 100GB of
raw text data.
Really? Do you get conforming results with 1,000 warehouses? What's
One year ago a Postgres teacher pointed me there:
http://it.toolbox.com/blogs/database-soup/postgresql-publishes-first-real-benchmark-17470
http://www.spec.org/jAppServer2004/results/res2007q3/jAppServer2004-20070606-00065.html
that would be just like what you're looking for.
Regards,
Stefano
O
Here is a query on a partitioned schema that produces a very bad query plan.
The tables are fully vacuumed, analyzed with stats target 40, and no bloat
(created with pure inserts, no updates or deletes).
I already know of at least three bugs with the query planner and partitions
listed at the
Victor Nawothnig wrote:
Hi,
I am looking for some recent and hopefully genuine comparisons between
Oracle and PostgreSQL regarding their performance in large scale
applications. Tests from real world applications would be preferable
but not required. Also differentiations in different areas (i.e
Mark Wong writes:
> On Dec 20, 2008, at 5:33 PM, Gregory Stark wrote:
>
>> "Mark Wong" writes:
>>
>>> To recap, dbt2 is a fair-use derivative of the TPC-C benchmark. We
>>> are using a 1000 warehouse database, which amounts to about 100GB of
>>> raw text data.
>>
>> Really? Do you get conformin
