Hi - I'm running into an OOM-killer issue when running a specific query (no
virtual machine running) and, based on researching the issue, I can
probably fix by making the following sysctl adjustments:
vm.overcommit_memory = 2
vm.overcommit_ratio = 0
However, I am perplexed as to why I am ru
On Mon, Dec 19, 2011 at 17:04, Rafael Martinez wrote:
> * Sudden decrease of swap when running backup/vacuum+analyze jobs
Do you know for certain that this memory use is attributed to
vacuum/analyze/backup, or are you just guessing? You should isolate
whether it's the vacuum or a backup process/b
Wow, upgrading 3 major releases at a go. :) It would probably be
useful to use the helpful:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
to get the information that is needed to the right people.
Regards,
Ken
On Mon, Dec 19, 2011 at 04:04:54PM +0100, Rafael Martinez wrote:
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
I am sending this email to ask if anyone has noticed a change in how
a server running postgreSQL 9.1 uses and allocates memory compared to
older versions.
We upgraded all our systems from 8.3 to 9.1 a couple of weeks ago, and
we have experience
