Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 754189FB690 for ; Mon, 23 Jul 2007 17:25:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 57511-04 for ; Mon, 23 Jul 2007 17:25:24 -0300 (ADT) X-Greylist: whitelisted by SQLgrey-1.7.5 Received: from mail03.syd.optusnet.com.au (mail03.syd.optusnet.com.au [211.29.132.184]) by postgresql.org (Postfix) with ESMTP id 4E97A9FA36E for ; Mon, 23 Jul 2007 17:25:22 -0300 (ADT) Received: from www3.nicku.org (c220-239-179-18.farfl1.nsw.optusnet.com.au [220.239.179.18]) by mail03.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l6NKPIjY017961; Tue, 24 Jul 2007 06:25:19 +1000 Received: from localhost (localhost.localdomain [127.0.0.1]) by www3.nicku.org (Postfix) with ESMTP id B5F16246FC2; Tue, 24 Jul 2007 06:25:18 +1000 (EST) X-Virus-Scanned: amavisd-new at example.com Received: from www3.nicku.org ([127.0.0.1]) by localhost (www3.nicku.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Dt9Kx+linz68; Tue, 24 Jul 2007 06:25:14 +1000 (EST) Received: by www3.nicku.org (Postfix, from userid 1000) id 9B751246FC7; Tue, 24 Jul 2007 06:25:14 +1000 (EST) Date: Tue, 24 Jul 2007 06:25:14 +1000 From: Nick Urbanik To: pgsql-admin@postgresql.org Subject: Re: How overcome wait for vacuum full? Message-ID: <20070723202514.GB25451@nicku.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <20070515221356.GG5264@nicku.org> <20070515225313.GV12731@alvh.no-ip.org> <20070515231616.GH5264@nicku.org> <20070516011252.GW12731@alvh.no-ip.org> <20070516012052.GC16310@nicku.org> <20070516012808.GF11533@nasby.net> <20070723193144.GA25451@nicku.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="ZfOjI3PrQbgiZnxM" Content-Disposition: inline In-Reply-To: <20070723193144.GA25451@nicku.org> User-Agent: Mutt/1.5.14 (2007-02-12) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.176 tagged_above=0 required=5 tests=AWL=-0.001, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, NORMAL_HTTP_TO_IP=0.001, WHOIS_REGISTERFLY=1.645 X-Spam-Level: X-Archive-Number: 200707/253 X-Sequence-Number: 26234 --ZfOjI3PrQbgiZnxM Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Dear Folks, On 24/07/07 05:31 +1000, Nick Urbanik wrote: >Dear Jim, > >On 15/05/07 20:28 -0500, Jim C. Nasby wrote: >>On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote: >>>Dear Alvaro, >>> >>>On 15/05/07 21:12 -0400, Alvaro Herrera wrote: >>> >Nick Urbanik wrote: >>> >>On 15/05/07 18:53 -0400, Alvaro Herrera wrote: >>> >You probably need to better configure the FSM settings. See >>> >fsm_max_pages in the docs. >>> >>>This is probably the critical piece of information we need to prevent >>>the need for another sleepless night and an outage! Thank you. >> >>http://www.pervasive-postgres.com/instantkb13/article.aspx?id=3D10087&cNo= de=3D5K1C3W >>might be of use as well. > >I have not been able to find this page; pervasive have moved their >site around. Any keywords in this article I can google for to find >the new URL? Thanks: I found a cache of the article, which is entitled, "Q10087 - INFO: Is PostgreSQL remembering what you vacuumed?" http://72.14.253.104/search?q=3Dcache:n_LQiTbm9joJ:www.pervasivepostgres.co= m/instantkb13/article.aspx%3Fid%3D10087+%22Is+PostgreSQL+remembering+what+y= ou+vacuumed%3F%22&hl=3Den&ct=3Dclnk&cd=3D2&gl=3Dau A simplistic summary is to do a full, verbose vacuum of the entire postgresql installation (of all the databases together), and then the last two lines contain output about FSM utilisation. The values of max_fsm_relations and max_fsm_pages should then be set in postgresql.conf in light of this information. --=20 Nick Urbanik RHCE http://nicku.org nicku@nicku.org GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24 --ZfOjI3PrQbgiZnxM Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFGpQ6qFt/sW7udLCQRAi/MAJ94pEjEb16xU+MsdFwXfCpr59/QFgCg3vlK 2cztKxfNz4ddexetRwnER3U= =KFdv -----END PGP SIGNATURE----- --ZfOjI3PrQbgiZnxM--