X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 69E8CD1B18E for ; Wed, 19 May 2004 17:11:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86155-06 for ; Wed, 19 May 2004 17:11:27 -0300 (ADT) Received: from lakermmtao06.cox.net (lakermmtao06.cox.net [68.230.240.33]) by svr1.postgresql.org (Postfix) with ESMTP id 18D1CD1B16E for ; Wed, 19 May 2004 17:11:25 -0300 (ADT) Received: from [192.168.123.110] (really [68.225.208.56]) by lakermmtao06.cox.net (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with ESMTP id <20040519201126.ITFX9256.lakermmtao06.cox.net@[192.168.123.110]> for ; Wed, 19 May 2004 16:11:26 -0400 Mime-Version: 1.0 X-Sender: usachurch@mail.absmot.com Message-Id: Date: Wed, 19 May 2004 13:11:25 -0700 To: pgsql-admin@postgresql.org From: admin@usachurch.com Subject: postgresql not using enough memory? Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/199 X-Sequence-Number: 13515 Hello list, I know this is a complicated issue, but I'll throw it out there... Our DB box has 3GB of ram - which is supposed to be used by postgres. Whenever I use top, it only shows about 800MB being used with 2.2GB free. What can I do to tell postgres to use more of that memory - maybe 2GB ? I am running on fedora core 1. as far as my postgrsql.conf file, here's the related settings: vacuum_mem = 16384 max_fsm_pages = 32001 max_fsm_relations = 2000 max_files_per_process = 10000 effective_cache_size = 100000 Also, in my /etc/sysctl.conf file, I have these lines: # added to allow a single app to have 512MB kernel.shmall = 536870912 kernel.shmmax = 536870912 Any ideas? Thanks, Devin