On Fri, 2006-04-28 at 22:38 +0200, Martijn van Oosterhout wrote: > On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote: > > > Martijn van Oosterhout <kleptog@svana.org> writes: > > >> You know, rather than adding new columns to pg_class, why not extend > > >> the stats collector to collect this information. > > > > That sounds doable. And a lot less scary for me (as a relative > > noobie) to do. > > Well, I've been thinking a bit more and it seems a perfect fit in many > ways. None of the info we're talking about here takes any extra time to > calculate, it's all debates about what to log. So send it to the stats > collector and let it deal with it. > > It should probably tie in with normal vacuum. We get requests from time > to time from people wanting to know the last time a table was vacuumed > (not autovacuumed) for example.
Good idea; Agreed. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
