Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E55B29FA17D for ; Thu, 30 Nov 2006 14:12:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 40997-01 for ; Thu, 30 Nov 2006 14:11:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id BAD419FA170 for ; Thu, 30 Nov 2006 14:11:54 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1974353ugf for ; Thu, 30 Nov 2006 10:11:53 -0800 (PST) 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=XJkmoJj3nFNM1K1Pd4DcED6G0DMDIDWcD/4g7NYHPwYy8rg1OKOCBaDdLxMbSYjHKlj8qB/uKk1k1zGvcBCXNHvsCfIV7l3vG6ds96YDam2loFyjFGR3wen6dD+84/40ffBHnhQo4PaX9nj5/hCdD76s95qx15RJjGZte41HwN8= Received: by 10.66.216.20 with SMTP id o20mr5827795ugg.1164910312881; Thu, 30 Nov 2006 10:11:52 -0800 (PST) Received: by 10.67.118.11 with HTTP; Thu, 30 Nov 2006 10:11:52 -0800 (PST) Message-ID: <55c095e90611301011y1d073754pe93c97eff3213d45@mail.gmail.com> Date: Thu, 30 Nov 2006 16:11:52 -0200 From: "Ezequias Rodrigues da Rocha" To: "Matthew T. O'Connor" Subject: Re: Autovaccum Cc: "Peter Childs" , pgsql-sql@postgresql.org In-Reply-To: <456F1E37.1030600@zeut.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90611300602n18fa7e8v8e985386f74afba1@mail.gmail.com> <20061130142406.GH15105@alvh.no-ip.org> <55c095e90611300703j580fef50tae19393af37f7988@mail.gmail.com> <456F1E37.1030600@zeut.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/298 X-Sequence-Number: 26950 Just a little question. What is the interval of time the vacuum will run on my database ? Ezequias 2006/11/30, Matthew T. O'Connor : > Ezequias Rodrigues da Rocha wrote: > > It is possible to set this up on PgAdmin ? > > I don't know. > > > I need to shutdown the postgresql service to change this parameters ? > > No, you can just modify the params in postgresql.conf and HUP the server > so that it re-reads the config file, no restart required. > > > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/