X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ABAE6329E6F for ; Mon, 18 Oct 2004 19:07:01 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68811-05 for ; Mon, 18 Oct 2004 18:06:54 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5B2C5329E57 for ; Mon, 18 Oct 2004 19:06:54 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9II6qRK027336; Mon, 18 Oct 2004 14:06:52 -0400 (EDT) To: Doug Y Cc: pgsql-admin@postgresql.org Subject: Re: Relations summary at end of vacuum In-reply-to: <4173FFCA.4090008@ptd.net> References: <4173FFCA.4090008@ptd.net> Comments: In-reply-to Doug Y message dated "Mon, 18 Oct 2004 13:39:22 -0400" Date: Mon, 18 Oct 2004 14:06:52 -0400 Message-ID: <27335.1098122812@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/217 X-Sequence-Number: 15210 Doug Y writes: > What exactly are the "Relations" that are referred to in the summary > at the end of a vacuum? Tables and indexes. > I have two DBs that are supposed to be mirrored copies of each other, > but my relation & page counts are different for each after a vacuum: IIRC, a relation won't get entered into the free space map at all if no useful free space is found by VACUUM. So if the only thing that ever happens on the mirror is insertion of new rows, I could believe that there would be many fewer active FSM entries than for the master. However the fact that the database with fewer FSM relations knows about more free pages within those tables seems a bit at variance with that idea. Maybe your mirror is insert-only for some tables and not others, and you've been lax about vacuuming the mirror? regards, tom lane