[CentOS] Centos/Linux Disk Caching, might be OT in some ways

Les Mikesell lesmikesell at gmail.com
Tue Jan 26 15:57:38 UTC 2010


On 1/26/2010 9:46 AM, Kwan Lowe wrote:
> On Tue, Jan 26, 2010 at 9:48 AM, Ross Walker<rswwalker at gmail.com>  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 at gmail.com


More information about the CentOS mailing list