Re: Another small bug (pg_autovacuum)

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-hackers(at)postgresql(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Subject: Re: Another small bug (pg_autovacuum)
Date: 2003-09-12 13:51:38
Message-ID: 3F61CF6A.4010407@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> "Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
>> 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.
>
> Hmm. The bufmgr and lower levels handle shared tables by always
> associating a database number of zero with them, but I'll bet that the
> pg_stats stuff does not do that. I'd call that a bug, yes. Jan, any
> thoughts on how complex to fix?

Need to take a look into, but I agree that this is a bug.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-12 13:51:39 Re: massive quotes?
Previous Message Tom Lane 2003-09-12 13:49:31 Re: [PATCHES] Reorganization of spinlock defines