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 134ADD9564 for ; Tue, 27 Sep 2005 00:03:35 -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 86539-06 for ; Tue, 27 Sep 2005 03:03:31 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.202]) by svr1.postgresql.org (Postfix) with ESMTP id 084BED8C85 for ; Tue, 27 Sep 2005 00:03:29 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id h32so693440wxd for ; Mon, 26 Sep 2005 20:03:29 -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=fC3v8xXJYsU1ql8Wn55nPdk7Hm6cDr2eAN3p3Uin5mhugqP0rEE2K8mt0k7kd7anl21IfCuI6JtC7Fr4Qzol6v3a2SP3ab6TaPOO/u84PymDDVc47SCmMrAY9v7RtIksSC7DcGiVcx+zMx4D/rcLFAGMQrrp3faj05Js4P3n5Gc= Received: by 10.54.17.14 with SMTP id 14mr4840wrq; Mon, 26 Sep 2005 20:03:29 -0700 (PDT) Received: by 10.54.17.61 with HTTP; Mon, 26 Sep 2005 20:03:29 -0700 (PDT) Message-ID: <1c66bda805092620032b9af8c6@mail.gmail.com> Date: Tue, 27 Sep 2005 15:03:29 +1200 From: adey Reply-To: adey To: Gourish Singbal Subject: Re: vacuum message Cc: Hannes Dorbath , pgsql-admin@postgresql.org In-Reply-To: <674d1f8a05092606583266eb3a@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3235_6740150.1127790209466" References: <674d1f8a05092606583266eb3a@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.627 required=5 tests=[FROM_ENDS_IN_NUMS=0.516, HTML_40_50=0.086, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/294 X-Sequence-Number: 19031 ------=_Part_3235_6740150.1127790209466 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline That's only 1.8mb of RAM, so I can't see it being a problems if you have no RAM shortage on your server. On 9/27/05, Gourish Singbal wrote: > > Thats a good Idea. > My output after full vaccum is :- > INFO: free space map: 9 relations, 114736 pages stored; 76592 total page= s > needed > DETAIL: Allocated FSM size: 1000 relations + 300000 pages =3D 1856 kB sha= red > memory. > VACUUM > I just have a Question: > Is the allocate pages 300000 okey ?. OR do i need to decrease it to 10000= 0 > ? > 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_3235_6740150.1127790209466 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline That's only 1.8mb of RAM, so I can't see it being a problems if you have no= RAM shortage on your server.

On 9/27/05, = Gourish Singbal <gourish@gmail.= com> wrote:
 
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:=20
On 23.09.2005 08:01, Adrian Enge= lbrecht wrote:
> You need to increase your max_fsm_pages to at least = 29584 pages to=20
> 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)---------------------------=20
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_3235_6740150.1127790209466--