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

Re: FreeBSD config

From: Dror Matalon <dror(at)zapatec(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: FreeBSD config
Date: 2004-02-26 21:58:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, Feb 27, 2004 at 05:47:47AM +0800, Christopher Kings-Lynne wrote:
> > We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
> > repeated advice on the mailing lists we configured effective_cache_size
> > = 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192
> >
> > Which results in using 200Megs for disk caching.
> effective_cache_size does nothing of the sort.  CHeck your
> shared_buffers value...


	Sets the optimizer's assumption about the effective size of the disk
	cache (that is, the portion of the kernel's disk cache that will be
	used for PostgreSQL data files). This is measured in disk pages, which
	are normally 8 kB each.
talks about how to programmatically determine the right setting for
	case `uname` in "FreeBSD")
	echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))"
	echo "Unable to automatically determine the effective cache size" >> /dev/stderr

which brings me back to my question why not make Freebsd use more of its
memory for disk caching and then tell postgres about it. 

> > Is there a reason not to increase the hibufspace beyond the 200 megs and
> > provide a bigger cache to postgres? I looked both on the postgres and
> > freebsd mailing lists and couldn't find a good answer to this.
> Well, maybe butnot necessarily.  It's better to leave the OS to look after
> most of your RAM.
> Chris

Dror Matalon
Zapatec Inc 
1700 MLK Way
Berkeley, CA 94709

In response to


pgsql-performance by date

Next:From: Troels ArvinDate: 2004-02-26 22:01:13
Subject: Re: Database Server Tuning
Previous:From: Christopher Kings-LynneDate: 2004-02-26 21:47:47
Subject: Re: FreeBSD config

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