Re: Optimizer not using index on 120M row table

On Wed, Apr 30, 2003 at 12:14:34AM -0400, Tom Lane wrote:
> Plenty, see many past threads in pgsql-performance and other lists.
> There are strong reasons to think that you should let the kernel do the
> bulk of the caching work.

OK, anyone have any ideas on how to get FreeBSD to cache more than 300M?
:)

BTW, all the searches I did on this topic and FreeBSD resulted in
results saying I should set shared_buffers way high, so it seems FBSD
users are having pgsql do the caching instead of the OS.
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"