Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BD4759F9386 for ; Tue, 19 Dec 2006 10:23:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 54279-06 for ; Tue, 19 Dec 2006 10:23:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id B3F619FA364 for ; Tue, 19 Dec 2006 10:23:02 -0400 (AST) Received: from kingfisher.intern.logix-tt.com (84-72-188-217.dclient.hispeed.ch [84.72.188.217]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 9E31164D12 for ; Tue, 19 Dec 2006 15:25:59 +0100 (CET) Received: from kingfisher.sec.intern.logix-tt.com (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 441F79772E for ; Tue, 19 Dec 2006 15:23:00 +0100 (CET) Date: Tue, 19 Dec 2006 15:23:00 +0100 From: Markus Schaber To: pgsql-sql@postgresql.org Subject: Re: Autovaccum Message-ID: <20061219152300.6d155f87@kingfisher.sec.intern.logix-tt.com> In-Reply-To: <55c095e90611301011y1d073754pe93c97eff3213d45@mail.gmail.com> References: <55c095e90611300602n18fa7e8v8e985386f74afba1@mail.gmail.com> <20061130142406.GH15105@alvh.no-ip.org> <55c095e90611300703j580fef50tae19393af37f7988@mail.gmail.com> <456F1E37.1030600@zeut.net> <55c095e90611301011y1d073754pe93c97eff3213d45@mail.gmail.com> Organization: www.logix-tt.com X-Mailer: Sylpheed-Claws 2.6.0 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/134 X-Sequence-Number: 27090 Hi, Ezequias, "Ezequias Rodrigues da Rocha" wrote: > What is the interval of time the vacuum will run on my database ? That depends on your settings and load. Autovacuum looks at every table, and checks the number of modifications, as well as the total number of transactions since the last vacuum, and decides whether to VACUUM and/or ANALYZE. The thresholds for those settings can be configured per table, with the defaults in the postgresql.conf. Regards, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org