Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0ACCD650048 for ; Tue, 15 Jul 2008 10:20:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71034-07 for ; Tue, 15 Jul 2008 10:19:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from hs-out-0708.google.com (hs-out-0708.google.com [64.233.178.241]) by postgresql.org (Postfix) with ESMTP id 4A0C865054D for ; Tue, 15 Jul 2008 10:19:50 -0300 (ADT) Received: by hs-out-0708.google.com with SMTP id x43so1395968hsb.3 for ; Tue, 15 Jul 2008 06:19:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=o3Af6o5TM+EMxvmIgv78W7mjZA19z+R42wR4VZNTPQo=; b=ISr0KEcrmKDhCzQTugG+tOmRD8wQXvrv6JHjMxQvKswusqo7J5Kf5MkvmOI7OSpm7T G1PZZrNihhAbyxPDWMhNmw01YsUh54AqkctE6WAVdDmDWQejvrgmaigXS7IAOBlvQTEW 7fRZglhWSiD1ANK/eqQ7ML2QC6c2LRY7oxRzc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=tYH0n5qknFwjpdeuR+KpqvzC5VgBPvxUtGNN2I6yZmqNxtTuKu1zq/KW1p0WFV1GqN vdbJnyxUuOKKUHi5trWIZRo2Qhvmfjl/xH8GZS7Hx5KW/g4qIpQYPpJEIW64mqH8wWhd DK90Oy1K5elVzFVGkDVZC1FTDteEtI+TpkQMk= Received: by 10.100.105.15 with SMTP id d15mr10650127anc.137.1216127988930; Tue, 15 Jul 2008 06:19:48 -0700 (PDT) Received: by 10.100.122.6 with HTTP; Tue, 15 Jul 2008 06:19:48 -0700 (PDT) Message-ID: <1d219a6f0807150619o567709ebu7d28429d2907bf82@mail.gmail.com> Date: Tue, 15 Jul 2008 09:19:48 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: More Autovacuum questions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7238_33032446.1216127988927" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/129 X-Sequence-Number: 29739 ------=_Part_7238_33032446.1216127988927 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Another question. When autovacuum sleeps, does it release the lock it has on the table? What we would like to have happen is for vacuum to work for a while, sleep, and while it is sleeping run an analyze on the table. We need this due to how quickly our data is changing. Currently we are running analyze every 5 minutes against the table of question and get a very serious performance hit when vacuum runs due to the index stats getting out of date. As soon as we rerun analyze after the vacuum happiness returns. The pg_total_relation_size for the table in question is 64GB, and as stated above is a very heavily used and modifed table. Thanks for any comments, Chris ------=_Part_7238_33032446.1216127988927 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Another question.

When autovacuum sleeps, does it release the lock it has on the table? 

What we would like to have happen is for vacuum to work for a while, sleep, and while it is sleeping run an analyze on the table.  We need this due to how quickly our data is changing.  Currently we are running analyze every 5 minutes against the table of question and get a very serious performance hit when vacuum runs due to the index stats getting out of date.  As soon as we rerun analyze after the vacuum happiness returns.

The pg_total_relation_size for the table in question is 64GB, and as stated above is a very heavily used and modifed table.

Thanks for any comments,

Chris
------=_Part_7238_33032446.1216127988927--