Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 92DACB5DC3C for ; Mon, 12 Sep 2011 14:04:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 73688-04 for ; Mon, 12 Sep 2011 17:04:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id 637F4B5DC1C for ; Mon, 12 Sep 2011 14:04:44 -0300 (ADT) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1R39vz-0006we-2q for pgsql-performance@postgresql.org; Mon, 12 Sep 2011 19:04:39 +0200 Received: from p5dc4ef5c.dip.t-dialin.net ([93.196.239.92]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 12 Sep 2011 19:04:39 +0200 Received: from shortcutter by p5dc4ef5c.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 12 Sep 2011 19:04:39 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Robert Klemme Subject: Re: Postgres for a "data warehouse", 5-10 TB Date: Mon, 12 Sep 2011 19:04:22 +0200 Lines: 21 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: p5dc4ef5c.dip.t-dialin.net User-Agent: Mozilla/5.0 (Windows NT 6.0; WOW64; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.393 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RP_MATCHES_RCVD=-0.504, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201109/146 X-Sequence-Number: 44922 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