Skip site navigation (1) Skip section navigation (2)

Relations summary at end of vacuum

From: Doug Y <dylists(at)ptd(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Relations summary at end of vacuum
Date: 2004-10-18 17:39:22
Message-ID: 4173FFCA.4090008@ptd.net (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-10-18 18:06:52
Subject: Re: Relations summary at end of vacuum
Previous:From: Joshua D. DrakeDate: 2004-10-18 15:53:21
Subject: Re: large dumps won't restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group