Patch applied as part of Christopher Browne's patch.
---------------------------------------------------------------------------
Matthew T. O'Connor wrote:
> On Fri, 2003-09-12 at 09:35, Bruce Momjian wrote:
> > Matthew T. O'Connor wrote:
> > > I made a patch to fix this, but in testing it I noticed that the stats
> > > system doesn't work on shared tables as I was expecting it too (as my
> > > latest patch requires it too :-). It treats instances of shared tables
> > > in separate databases as totally unique tables. This makes it hard to
> > > know how much activity has really gone on for a shared table.
> > >
> > > Is the behavior of the following example expected / desired?
> >
> > I suspect is just a bug because no one noticed it before. As I
> > understand it, the stats system is recorded per-database. We could add
> > stuff so the global tables are only recorded in template1 or perhaps
> > record in template1 but report template1's numbers for all databases.
>
> OK, well as we wait on the fix for the stats system, let me submit my
> patch for pg_autovacuum. This patch assumes that the stats system will
> be fixed so that all inserts, updates and deletes performed on shared
> tables reguardless of what database those commands were executed from,
> will show up in the stats shown in each database.
>
> Even if this the stats system isn't fixed, this patch still is much
> better about monitoring system tables that aren't shared, so it's an
> improvement no matter what.
>
> Matthew T. O'Connor
>
>
[ Attachment, skipping... ]
[ Attachment, skipping... ]
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
