Re: Centos/Linux Disk Caching, might be OT in some ways

[Les Mikesell <lesmikesell@xxxxxxxxx>]

On 1/26/2010 9:46 AM, Kwan Lowe wrote:
> On Tue, Jan 26, 2010 at 9:48 AM, Ross Walker<rswwalker@xxxxxxxxx>  wrote:
>
>> Some really nice things are happening with postgresql as well, you
>> should check it out.
>>
>
> This was a great thread. For one, it's interesting to see the
> approaches you can take to solve an issue. I.e., we can tune the OS to
> quite a degree, but many times just optimizing a query can lead to
> much greater improvements. We can also sometimes throw hardware at the
> problem; and sometimes doing that is faster/cheaper than a heuristic
> approach :D.

Or, if the issue is scaling up the number of reads for web access you 
might be able to simply add caching in the web app, either locally or 
with a distributed tool like memcache to offload the work from the DB.

-- 
   Les Mikesell
    lesmikesell@xxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos