Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3285D632845 for ; Sat, 1 May 2010 13:08:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 94001-04 for ; Sat, 1 May 2010 16:08:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id 695286326E2 for ; Sat, 1 May 2010 13:08:37 -0300 (ADT) Received: by gwj19 with SMTP id 19so570322gwj.19 for ; Sat, 01 May 2010 09:08:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=3YlqL6CsFr/A0bIaS6a+a6fXx1rdpg5vanl+bZThyP4=; b=Vp4FydgZazkI4O6iDzYNdKXfyaXjVWGmu6lKWlXXE+CuL9oYp73tjcuNZGoMMJOVV8 NjTv3ncasQoC51r++XHuogu6NVQIy67ahloxs8PvzkzZODNVH/LCsNRxhOtpGGhPMhm1 Y7ZeUXTYOwmlLCUBxEmn9Q+h0Px3b/fEhrNpw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=dHy2L4XXnkj8+Q5iywpScLVTmqCu6EUpsN//5KWfXMq60DDLbR5wkhJdkKwaTai4dV RjxHC7ukAoIyGTMwTK7eSoZAs+iZuNxDR+HXoMt7EMxaNSOYo1a2XyilQ6rUiHuUfW6u TI+MXAVGPdlKcR6TPtIK4ULS8FfcCv8Ie0nwA= MIME-Version: 1.0 Received: by 10.150.48.27 with SMTP id v27mr4978064ybv.53.1272730116190; Sat, 01 May 2010 09:08:36 -0700 (PDT) Received: by 10.150.134.20 with HTTP; Sat, 1 May 2010 09:08:36 -0700 (PDT) In-Reply-To: References: <65d9d15d-41d2-4bfa-8cc3-6148b4fb9022@z3g2000yqz.googlegroups.com> Date: Sat, 1 May 2010 10:08:36 -0600 Message-ID: Subject: Re: autovacuum strategy / parameters From: Scott Marlowe To: Thomas Kellerer Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201005/5 X-Sequence-Number: 38589 On Wed, Apr 28, 2010 at 8:20 AM, Thomas Kellerer wrote: > Rick, 22.04.2010 22:42: >> >> So, in a large table, the scale_factor is the dominant term. In a >> small table, the threshold is the dominant term. But both are taken into >> account. >> >> The default values are set for small tables; it is not being run for >> large tables. > > With 8.4 you can adjust the autovacuum settings per table... You can as well with 8.3, but it's not made by alter table but by pg_autovacuum table entries.