Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xy6nL-0004e6-ON for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2014 22:28:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xy6nL-0007SI-7b for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2014 22:28:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xy6nJ-0007Pd-I1 for pgsql-admin@postgresql.org; Mon, 08 Dec 2014 22:28:41 +0000 Received: from internet06.ebureau.com ([65.127.24.25]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xy6nB-0008Oj-AB for pgsql-admin@postgresql.org; Mon, 08 Dec 2014 22:28:40 +0000 Received: from localhost (localhost [127.0.0.1]) by internet06.ebureau.com (Postfix) with ESMTP id C37942EBF31B for ; Mon, 8 Dec 2014 16:32:06 -0600 (CST) X-Virus-Scanned: amavisd-new at ebureau.com Received: from internet06.ebureau.com ([127.0.0.1]) by localhost (internet06.ebureau.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Y8-iuXp5itvd for ; Mon, 8 Dec 2014 16:32:06 -0600 (CST) Received: from [192.168.0.5] (unknown [209.181.196.218]) by internet06.ebureau.com (Postfix) with ESMTPSA id 63A2D2EBF30A for ; Mon, 8 Dec 2014 16:32:06 -0600 (CST) From: Natalie Wenz Content-Type: multipart/alternative; boundary="Apple-Mail=_FB0BAD8F-5A69-41D0-9DBE-9B6CFBD49569" Subject: autovacuum to prevent wraparound question Message-Id: Date: Mon, 8 Dec 2014 16:28:19 -0600 To: pgsql-admin@postgresql.org Mime-Version: 1.0 (Mac OS X Mail 8.1 \(1993\)) X-Mailer: Apple Mail (2.1993) X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail=_FB0BAD8F-5A69-41D0-9DBE-9B6CFBD49569 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Does the auto vacuum process scan the whole database every time it runs = (when triggered to prevent wraparound), or is it able to skip pages for = which every row has already been frozen? We have a large database that consists primarily of two large tables = that receive a lot of insert records, but no rows are ever deleted or = changed. Can we expect the autovacuum to always take longer and longer = as those tables grow, scanning every row every time it is triggered to = prevent wraparound, or is the vacuumer optimized to skip the parts that = have already been frozen?=20 Thanks, Natalie= --Apple-Mail=_FB0BAD8F-5A69-41D0-9DBE-9B6CFBD49569 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Does the auto vacuum = process scan the whole database every time it runs (when triggered to = prevent wraparound), or is it able to skip pages for which every row has = already been frozen?

We have a large database that consists primarily of = two large tables that receive a lot of insert records, but no rows are = ever deleted or changed. Can we expect the autovacuum to always = take longer and longer as those tables grow, scanning every row every = time it is triggered to prevent wraparound, or is the vacuumer = optimized to skip the parts that have already been = frozen? 

Thanks,
Natalie
= --Apple-Mail=_FB0BAD8F-5A69-41D0-9DBE-9B6CFBD49569--