From: Mark Lewis <mark.lewis@mir3.com>
To: Fredrik Israelsson <fredrik.israelsson@eu.biotage.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Is this way of testing a bad idea?
Date: Thu, 24 Aug 2006 06:40:19 -0700
Message-ID: <1156426819.9657.227.camel@archimedes> (raw)
In-Reply-To: <B6D0C6EF9C7B5C48AB71BDB7334C9FFABD5522@seuppms101.eu.companyb.com>
References: <B6D0C6EF9C7B5C48AB71BDB7334C9FFABD5522@seuppms101.eu.companyb.com>
> Monitoring the processes using top reveals that the total amount of
> memory used slowly increases during the test. When reaching insert
> number 40000, or somewhere around that, memory is exhausted, and the the
> systems begins to swap. Each of the postmaster processes seem to use a
> constant amount of memory, but the total memory usage increases all the
> same.
So . . . . what's using the memory? It doesn't sound like PG is using
it, so is it your Java app?
If it's the Java app, then it could be that your code isn't remembering
to do things like close statements, or perhaps the max heap size is set
too large for your hardware. With early RHEL3 kernels there was also a
quirky interaction with Sun's JVM where the system swaps itself to death
even when less than half the physical memory is in use.
If its neither PG nor Java, then perhaps you're misinterpreting the
results of top. Remember that the "free" memory on a properly running
Unix box that's been running for a while should hover just a bit above
zero due to normal caching; read up on the 'free' command to see the
actual memory utilization.
-- Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.lewis@mir3.com, fredrik.israelsson@eu.biotage.com
Subject: Re: Is this way of testing a bad idea?
In-Reply-To: <1156426819.9657.227.camel@archimedes>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox