Re: pgstat_drop_relation bugfix - Mailing list pgsql-patches

From ITAGAKI Takahiro
Subject Re: pgstat_drop_relation bugfix
Date
Msg-id 20070713170023.8E14.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: pgstat_drop_relation bugfix  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgstat_drop_relation bugfix
List pgsql-patches
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > What I'm inclined to propose is that we just remove the
> > pgstat_drop_relation() call from smgr_internal_unlink
> On checking the CVS history, that in fact is how the code worked before
> 8.1.3, when I introduced the bogus call in a fit of over-optimization :-(.

I'm worried that we leave garbage entries in the stats. As you suggested,
don't we need to remove unreferenced entries from stats periodically?

> > and rely entirely
> > on VACUUM to clean out dead entries in the pgstats data.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center



pgsql-patches by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: GSSAPI support on OpenBSD
Next
From: "Simon Riggs"
Date:
Subject: Re: [BUGS] BUG #3439: pg_standby and path name with space