Re: Big trouble with memory !! - Mailing list pgsql-general

From Tom Lane
Subject Re: Big trouble with memory !!
Date
Msg-id 6507.1112826421@sss.pgh.pa.us
Whole thread Raw
In response to Re: Big trouble with memory !!  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> Ok, I think the point I'm trying to make is that with "strict
> autocommit" in its current state isn't really that strict and just
> causes the problem to happen elsewhere.

Right, but that is surely just a kernel bug, and one that's not been
around very long.  Presumably it'll be fixed soon.

> That formula they use is bizarre.

I presume that the point of the formula is that you want some fraction
of physical RAM to be reserved for disk buffers ... 50% might be
unreasonably high, or not ...

            regards, tom lane

pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: lower function
Next
From: "David Parker"
Date:
Subject: Re: monitoring database activity on solaris