Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How

From: Steve Poe <spoe(at)sfnet(dot)cc>
To: "Mohan, Ross" <RMohan(at)arbinet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
Date: 2005-04-15 18:11:40
Message-ID: 426003DC.2020008@sfnet.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ross,

I agree with you, but I' am the lowly intergrator/analyst, I have to solve the problem without all
the authority (sounds like a project manager). I originally started this thread since I had the $7k budget.

I am not a dba/developer. but I play one on t.v., so I can only assume that throwing money
at the application code means one understand what the bottleneck in the code and what it takes to fix it.

In this situation, the code is hidden by the vendor that connects to the database. So, besides persisent requests of the vendor to improve the area of the application, the balance of tuning lies with the hardware. The answer is *both* hardware and application code. Finding the right balance is key. Your mileage may vary.

Steve Poe

>If, however, in the far-more-likely case that the application code
>or system/business process is the throttle point, it'd be a great
>use of money to have a test report showing that to the "higher ups".
>That's where the best scalability bang-for-buck can be made.

- Ross

>p.s. having said this, and as already been noted "7K" ain't
> going to buy that much....maybe the ability to go RAID 10?

>p.p.s Why don't we start a PGSQL-7K listserv, to handle this EPIC thread? :-)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joel Fradkin 2005-04-15 18:15:15 Re: speed of querry?
Previous Message Greg Stark 2005-04-15 18:01:41 Re: How to improve db performance with $7K?