Re: Manipulating disk cache (buf) settings

2005-05-24 Thread Vivek Khera
On May 23, 2005, at 7:29 PM, John-Mark Gurney wrote: Vivek Khera wrote this message on Mon, May 23, 2005 at 17:17 -0400: Cool... So what would you recommend telling an application like Postgres what the cache size is? All of RAM? That seems unlikely given much of the ram is used for other

Manipulating disk cache (buf) settings

2005-05-23 Thread Sven Willenberger
We are running a PostgreSQL server (8.0.3) on a dual opteron system with 8G of RAM. If I interpret top and vfs.hibufspace correctly (which show values of 215MB and 225771520 (which equals 215MB) respectively. My understanding from having searched the archives is that this is the value that is used

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread Vivek Khera
On May 23, 2005, at 10:58 AM, Sven Willenberger wrote: We are running a PostgreSQL server (8.0.3) on a dual opteron system with 8G of RAM. If I interpret top and vfs.hibufspace correctly (which show values of 215MB and 225771520 (which equals 215MB) respectively. My understanding from having

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread John-Mark Gurney
Sven Willenberger wrote this message on Mon, May 23, 2005 at 10:58 -0400: We are running a PostgreSQL server (8.0.3) on a dual opteron system with 8G of RAM. If I interpret top and vfs.hibufspace correctly (which show values of 215MB and 225771520 (which equals 215MB) respectively. My

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread Sven Willenberger
On Mon, 2005-05-23 at 10:44 -0700, John-Mark Gurney wrote: Sven Willenberger wrote this message on Mon, May 23, 2005 at 10:58 -0400: We are running a PostgreSQL server (8.0.3) on a dual opteron system with 8G of RAM. If I interpret top and vfs.hibufspace correctly (which show values of

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread Vivek Khera
On May 23, 2005, at 1:44 PM, John-Mark Gurney wrote: This is incorrect... FreeBSD merged the vm and buf systems a while back, so all of memory is used as a disk cache.. The buf cache is still used for filesystem meta data (and for pending writes of files, but those buf's reference the

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread John-Mark Gurney
Vivek Khera wrote this message on Mon, May 23, 2005 at 17:17 -0400: On May 23, 2005, at 1:44 PM, John-Mark Gurney wrote: This is incorrect... FreeBSD merged the vm and buf systems a while back, so all of memory is used as a disk cache.. The buf cache is still used for filesystem meta

Re: Manipulating disk cache (buf) settings

2005-05-23 Thread Bruce Evans
On Mon, 23 May 2005, John-Mark Gurney wrote: Sven Willenberger wrote this message on Mon, May 23, 2005 at 10:58 -0400: We are running a PostgreSQL server (8.0.3) on a dual opteron system with 8G of RAM. If I interpret top and vfs.hibufspace correctly (which show values of 215MB and 225771520