> What is it about the buffer cache that makes it so unhappy being able
> hold everything? I don't want to be seen as a cache hit fascist, but
> it just better if the data is just *there*, available in the
> address space ready for each backend process to access it, rather than
> expecting the Linux cache mechanism, optimised as it may be, to have
> the caching?
The disk cache on most operating systems is optimized. Plus, keeping
shared buffers low gives you more room to bump up the sort memory, which
will make your big queries run faster.
pgsql-performance by date
|Next:||From: Bill Chandler||Date: 2004-07-09 15:18:48|
|Subject: Re: Terrible performance after deleting/recreating indexes|
|Previous:||From: Andy Ballingall||Date: 2004-07-09 09:28:24|
|Subject: Re: Working on huge RAM based datasets|