Skip site navigation (1) Skip section navigation (2)

Re: slow select

From: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow select
Date: 2003-10-27 06:32:42
Message-ID: 3F9CBC0A.1070706@myrealbox.com (view raw or flat)
Thread:
Lists: pgsql-performance
Vivek Khera wrote:
>>>>>>"JB" == Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 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.

Actually I wanted to ask this question for long time. Can we have guidelines 
about how to set effective cache size for various OSs?

Linux is pretty simple. Everything free is buffer cache. FreeBSD, not so 
straightforward but there is a sysctl..

How about HP-UX, Solaris and AIX? Other BSDs? and most importantly windows?

That could add much value to the tuning guide. Isn't it?

  Shridhar


In response to

pgsql-performance by date

Next:From: Dror MatalonDate: 2003-10-27 07:17:03
Subject: Re: Various performance questions
Previous:From: Christopher BrowneDate: 2003-10-27 06:04:49
Subject: Re: Various performance questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group