freebsd-performance mailing list

FromSubjectsort iconDate
Nicolas Haller
Re: tunning disk cache for pgsql?
Interresting. My DB is not heavily loaded yet so I don't see any problem at this time. I just follow recommendations. I thought Postgresql write and Ok, so when Postgresql doing a query for a second time for (very simple) example, FreeBSD can retrieve data from inactive mem too? Someone knows if there is a page which explains FreeBSD mechanisms about memory and fs cache management? I think I must read something on it :-) Thanks, -- Nicolas ...
Dec 31, 2:06 am 2010
Jim Nasby
Re: tunning disk cache for pgsql?
The Cache reported by top in FreeBSD isn't filesystem cache; it's a cache for some internal stuff. Buf are filesystem buffers, but they're not the only mechanism for the OS to cache data. Most data is actually cached via active and inactive pages. -- Jim C. Nasby, Database Architect jim@nasby.net 512.569.9461 (cell) http://jim.nasby.net _______________________________________________ freebsd-performance@freebsd.org mailing ...
Dec 30, 5:15 pm 2010
previous daytodaynext day
December 28, 2010December 31, 2010None