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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
