Re: Big trouble with memory !!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Hervé Piedvache <herve(at)elma(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Big trouble with memory !!
Date: 2005-04-06 22:27:01
Message-ID: 6507.1112826421@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Otto Blomqvist 2005-04-06 22:31:45 Re: [GENERAL] Problems with Set Returning Functions (SRFs)
Previous Message Mage 2005-04-06 22:26:10 Re: lower function