On Tue, 2005-10-11 at 09:41 +0200, Claus Guttesen wrote:
I have a postgresql 7.4.8-server with 4 GB ram.
snip
#effective_cache_size = 1000# typically 8KB each
This is computed by sysctl -n vfs.hibufspace / 8192 (on FreeBSD). So I
changed it to:
effective_cache_size = 27462#
Realise also that unless you are running the 1.5 x86-64 build, java
will not use more than 1Gig, and if the app server requests more than
1gig, Java will die (I've been there) with an out of memory error, even
though there is plenty of free mem available. This can easily be
cause by a lazy GC
Well - to each his own I guess - we did extensive testing on 1.4, and
it refused to allocate much past 1gig on both Linux x86/x86-64 and
Windows.
AlexOn 10/11/05, Alan Stange [EMAIL PROTECTED] wrote:
Alex Turner wrote: Perhaps this is true for 1.5 on x86-32 (I've only used it on x86-64) but I was
I have a SUSE 9 box that is running Postgres 8.0.1 compiled from source.
Over time, I see the memory usage of the box go way way up (it's got
8GBs in it and by the end of the day, it'll be all used up) with what
looks like cached inodes relating to the extreme IO generated by
I was wondering
Jon Brisbin [EMAIL PROTECTED] writes:
I have a SUSE 9 box that is running Postgres 8.0.1 compiled from source.
Over time, I see the memory usage of the box go way way up (it's got
8GBs in it and by the end of the day, it'll be all used up) with what
looks like cached inodes relating to the
Tom Lane wrote:
Are you sure it's not cached data pages, rather than cached inodes?
If so, the above behavior is *good*.
People often have a mistaken notion that having near-zero free RAM means
they have a problem. In point of fact, that is the way it is supposed
to be (at least on Unix-like
Jon Brisbin wrote:
Tom Lane wrote:
Are you sure it's not cached data pages, rather than cached inodes?
If so, the above behavior is *good*.
People often have a mistaken notion that having near-zero free RAM means
they have a problem. In point of fact, that is the way it is supposed
to
Jon Brisbin [EMAIL PROTECTED] writes:
Tom Lane wrote:
If you're not swapping then you do not have a problem.
Except for the fact that my Java App server crashes when all the
available memory is being used by caching and not reclaimed :-)
That's a kernel bug (or possibly a Java bug ;-)). I