Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres for a "data warehouse", 5-10 TB - Mailing list pgsql-performance

From Robert Klemme
Subject Re: Postgres for a "data warehouse", 5-10 TB
Date
Msg-id j4le2q$asc$1@dough.gmane.org
Whole thread Raw
In response to Re: Postgres for a "data warehouse", 5-10 TB  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Postgres for a "data warehouse", 5-10 TB  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
On 11.09.2011 22:10, Scott Marlowe wrote:

> Another data point.  We had a big Oracle installation at my last job,
> and OLAP queries were killing it midday, so I built a simple
> replication system to grab rows from the big iron Oracle SUN box and
> shove into a single core P IV 2.xGHz machine with 4 120G SATA drives
> in SW RAID-10.
>
> That machine handily beat the big iron Oracle machine at OLAP queries,
> running in 20 minutes what was taking well over an hour for the big
> Oracle machine to do, even during its (Oracle machine) off peak load
> times.

Um, that sounds as if the SUN setup was really bad.  Do you remember any
details about the drive configuration there?

Kind regards

    robert

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Re: How to track number of connections and hosts to Postgres cluster
Next
From: Robert Klemme
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB