X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA91FD7274 for ; Tue, 11 Oct 2005 08:39:08 -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 93399-09 for ; Tue, 11 Oct 2005 11:38:58 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 59274D79A2 for ; Tue, 11 Oct 2005 08:36:23 -0300 (ADT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr2.postgresql.org (Postfix) with ESMTP id EA3DFF119C for ; Tue, 11 Oct 2005 08:31:11 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 71so178057wra for ; Tue, 11 Oct 2005 00:41:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cHtvEgwfuoVW2I7lVQ34kRGUwZ0qwunEaDhg36PnKGjG6gpZNaHQHlVUhKGXkEgGTrvE3LJ1b03gebdSl6ACpsCVMgHKr1yp16l3Nisou4a3YFXpNQ5i4XKTIzOVpFrpC2Ad9X4NR81yjM0B252mf7Hg6iarCkvN6kevWVW2wLk= Received: by 10.54.117.4 with SMTP id p4mr3474023wrc; Tue, 11 Oct 2005 00:41:32 -0700 (PDT) Received: by 10.54.144.4 with HTTP; Tue, 11 Oct 2005 00:41:32 -0700 (PDT) Message-ID: Date: Tue, 11 Oct 2005 09:41:32 +0200 From: Claus Guttesen To: Jon Brisbin Subject: Re: Performance on SUSE w/ reiserfs Cc: pgsql-performance@postgresql.org In-Reply-To: <434AE7A1.3050700@npcinternational.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <434ADD46.5060206@npcinternational.com> <434AE7A1.3050700@npcinternational.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/186 X-Sequence-Number: 14954 I have a postgresql 7.4.8-server with 4 GB ram. > #max_fsm_pages =3D 20000 # min max_fsm_relations*16, 6 bytes eac= h > #max_fsm_relations =3D 1000 # min 100, ~50 bytes each If you do a vacuum verbose (when it's convenient) the last couple of lines will tell you something like this: INFO: free space map: 143 relations, 62034 pages stored; 63792 total pages needed DETAIL: Allocated FSM size: 300 relations + 75000 pages =3D 473 kB shared = memory. It says 143 relations and 63792 total pages needed, so I up'ed my values to these settings: max_fsm_relations =3D 300 # min 10, fsm is free space map, ~40 byte= s max_fsm_pages =3D 75000 # min 1000, fsm is free space map, ~6 byt= es > #effective_cache_size =3D 1000 # typically 8KB each This is computed by sysctl -n vfs.hibufspace / 8192 (on FreeBSD). So I changed it to: effective_cache_size =3D 27462 # typically 8KB each Bear in mind that this is 7.4.8 and FreeBSD so these suggestions may not apply to your environment. These suggestions could be validated by the other members of this list. regards Claus