Re: slow select - Mailing list pgsql-performance

From Vivek Khera
Subject Re: slow select
Date
Msg-id 16281.18548.53239.394135@yertle.int.kciLink.com
Whole thread Raw
In response to Re: slow select  (Josh Berkus <josh@agliodbs.com>)
Responses Re: slow select
List pgsql-performance
>>>>> "JB" == Josh Berkus <josh@agliodbs.com> writes:

JB> Vivek,
>> Assuming your OS will use that much RAM for the cache... the whole
>> world's not Linux :-)

JB> It's not?   Darn!

:-)

JB> Actually, what OS's can't use all idle ram for kernel cache?  I
JB> should note that in my performance docs ....

FreeBSD.  Limited by the value of "sysctl vfs.hibufspace" from what I
understand.  This value is set at boot based on available RAM and some
other tuning parameters.

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: vacuum locking
Next
From: Vivek Khera
Date:
Subject: Re: My own performance/tuning q&a