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 DED65329F3E for ; Mon, 18 Oct 2004 18:39:30 +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 58174-08 for ; Mon, 18 Oct 2004 17:39:28 +0000 (GMT) Received: from neomail02.traderonline.com (email.traderonline.com [65.213.231.10]) by svr1.postgresql.org (Postfix) with ESMTP id 95ABB329F37 for ; Mon, 18 Oct 2004 18:39:25 +0100 (BST) Received: from [192.168.1.68] (64-139-89-109-ubr02b-epensb01-pa.hfc.comcastbusiness.net [64.139.89.109]) by neomail02.traderonline.com (8.12.10/8.12.8) with ESMTP id i9IHdLdh003941 for ; Mon, 18 Oct 2004 13:39:22 -0400 Message-ID: <4173FFCA.4090008@ptd.net> Date: Mon, 18 Oct 2004 13:39:22 -0400 From: Doug Y User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Relations summary at end of vacuum Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/216 X-Sequence-Number: 15209 Hi, What exactly are the "Relations" that are referred to in the summary at the end of a vacuum? 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: DB_a: INFO: free space map: 109 relations, 70413 pages stored; 71696 total pages needed DETAIL: Allocated FSM size: 1000 relations + 100000 pages = 647 kB shared memory. DB_b: INFO: free space map: 281 relations, 57954 pages stored; 61904 total pages needed DETAIL: Allocated FSM size: 1000 relations + 100000 pages = 647 kB shared memory. The schemas and DBs are set up exactly the same, so I'm rather confused as to the discrepancy. Data checks (sums on key columns, etc) show that the data does appear to be in sync. I checked pg_tables, pg_indexes, and both have the same info. If this is normal behavior, I'd just like some additional info to set my mind at ease. Thanks