Re: Poor performance on seq scan

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>, "Laszlo Nagy" <gandalf(at)designaproduct(dot)biz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on seq scan
Date: 2006-09-13 20:33:48
Message-ID: C12DB93C.30DDC%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Lazlo,

>> Thank you for your suggestions. Looks like I need to buy SCSI disks.
>
> Well before you go do that try the areca SATA raid card

Yes, by all means spend $200 and buy the Areca or 3Ware RAID card - it's a
simple switch out of the cables and you should be golden.

Again - you should only expect an increase in performance from 4-6 times
from what you are getting now unless you increase the number of disks.

- Luke

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-09-13 20:51:53 Re: sql-bench
Previous Message Joshua Marsh 2006-09-13 20:27:47 Re: Performance With Joins on Large Tables