X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 52D65D1B18F;
	Fri, 11 Jun 2004 08:53:26 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 58241-08; Fri, 11 Jun 2004 11:53:20 +0000 (GMT)
Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208])
	by svr1.postgresql.org (Postfix) with ESMTP id 2192DD1B17B;
	Fri, 11 Jun 2004 08:53:16 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by bugs.unl.edu.ar (Postfix) with ESMTP
	id 475B411E1D; Fri, 11 Jun 2004 08:48:55 -0300 (ART)
Received: from bugs.unl.edu.ar ([127.0.0.1])
	by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
	id 00878-01; Fri, 11 Jun 2004 08:48:53 -0300 (ART)
Received: from localhost (localhost [127.0.0.1])
	by bugs.unl.edu.ar (Postfix) with ESMTP
	id BB47011E1B; Fri, 11 Jun 2004 08:48:52 -0300 (ART)
From: Martin Marques <martin@bugs.unl.edu.ar>
To: Mark Striebeck <mstriebeck@vasoftware.com>
Subject: Re: [GENERAL] out of memory error
Date: Fri, 11 Jun 2004 08:48:49 -0300
User-Agent: KMail/1.6.2
References: <40C90778.4090308@vasoftware.com>
In-Reply-To: <40C90778.4090308@vasoftware.com>
Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200406110848.49635.martin@bugs.unl.edu.ar>
X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at unl.edu.ar
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200406/148
X-Sequence-Number: 13808

El Jue 10 Jun 2004 22:14, escribi=F3:
> Hi,
>
> we are using Postgres with a J2EE application (JBoss) and get
> intermittent "out of memory" errors on the Postgres database. We are
> running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the
> following parameters:
>
> shared_buffers =3D 8192

This is very low for a 2GB server. Unless the server is overdimensioned. Th=
ink=20
that those 8192 are about 64 MB, and you have 2000 MB of fisical memory.

Also check that query which is hugh, and has to many unions.

--=20
 08:40:02 up 27 days, 18:51,  1 user,  load average: 1.16, 1.07, 0.75
-----------------------------------------------------------------
Mart=EDn Marqu=E9s        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------