X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3F3FDD9727 for ; Mon, 26 Sep 2005 10:58:36 -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 92965-04 for ; Mon, 26 Sep 2005 13:58:27 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by svr1.postgresql.org (Postfix) with ESMTP id 3D669D971E for ; Mon, 26 Sep 2005 10:58:26 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z31so6713nzd for ; Mon, 26 Sep 2005 06:58:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=MijUQyx6DrhRH2wV0OdAfoZvot7wuvrjjnPHqZ/Nr3PhwYazmQxUtCL85ZdSwRFI0WwwZBnVSkFZ+mh2QcnpOto2QqB1OoqdqbuDh00ISGJbiHicFmsBPN4kDJR1lRRVSq7Mg6OIXHF09s9SIRy39O+6rUMplk+WsHOOVHc0lGQ= Received: by 10.36.250.38 with SMTP id x38mr1514439nzh; Mon, 26 Sep 2005 06:58:30 -0700 (PDT) Received: by 10.36.74.7 with HTTP; Mon, 26 Sep 2005 06:58:30 -0700 (PDT) Message-ID: <674d1f8a05092606583266eb3a@mail.gmail.com> Date: Mon, 26 Sep 2005 19:28:30 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: Hannes Dorbath Subject: Re: vacuum message Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18421_25254223.1127743110954" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.108 required=5 tests=[AWL=0.027, HTML_30_40=0.056, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/289 X-Sequence-Number: 19026 ------=_Part_18421_25254223.1127743110954 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thats a good Idea. My output after full vaccum is :- INFO: free space map: 9 relations, 114736 pages stored; 76592 total pages needed DETAIL: Allocated FSM size: 1000 relations + 300000 pages =3D 1856 kB share= d memory. VACUUM I just have a Question: Is the allocate pages 300000 okey ?. OR do i need to decrease it to 100000 = ? regards Gouirsh Singbal On 9/23/05, Hannes Dorbath wrote: > > On 23.09.2005 08:01, Adrian Engelbrecht wrote: > > You need to increase your max_fsm_pages to at least 29584 pages to > > accommodate / monitor all free pages. > > Better set it to much more to have some room for future growth, 50000 > maybe. > > > -- > Regards, > Hannes Dorbath > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Best, Gourish Singbal ------=_Part_18421_25254223.1127743110954 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
Thats a good Idea.
 
My output after full vaccum is :-
 
INFO:  free space map: 9 relations, 114736 pages stored; 76592 to= tal pages needed
DETAIL:  Allocated FSM size: 1000 relations + 3000= 00 pages =3D 1856 kB shared memory.
VACUUM
 
I just have a Question:
Is the allocate pages 300000 okey ?. OR do i need to decrease it to 10= 0000 ?
 
regards
Gouirsh Singbal

 
On 9/23/05, = Hannes Dorbath <light@= theendofthetunnel.de> wrote:
On 23.09.2005 08:01, Adrian Enge= lbrecht wrote:
> You need to increase your max_fsm_pages to at least = 29584 pages to
> accommodate / monitor all free pages.

Better set it to much= more to have some room for future growth, 50000 maybe.


--
Re= gards,
Hannes Dorbath

---------------------------(end of broadcas= t)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate      subscribe-nomail command to majordomo@postgresql.org so that your=
      message can get through to the mail= ing list cleanly



--
Best,
Gourish Si= ngbal=20 ------=_Part_18421_25254223.1127743110954--