Re: keeping a timestamp of the last stats reset (for a db, table and function)
От | Jim Nasby |
---|---|
Тема | Re: keeping a timestamp of the last stats reset (for a db, table and function) |
Дата | |
Msg-id | 1F8EECEB-9C01-449A-8BBF-BFF6D553B74F@nasby.net обсуждение исходный текст |
Ответ на | Re: keeping a timestamp of the last stats reset (for a db, table and function) (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: keeping a timestamp of the last stats reset (for a
db, table and function)
|
Список | pgsql-hackers |
On Dec 18, 2010, at 8:51 PM, Tom Lane wrote: > Tomas Vondra <tv@fuzzy.cz> writes: >> I've done several small changes to the patch, namely > >> - added docs for the functions (in SGML) >> - added the same thing for background writer > >> So I think now it's 'complete' and I'll add it to the commit fest in a >> few minutes. > > Please split this into separate patches for database-level and > table-level tracking, because I think it's highly likely that the latter > will get rejected. We have had multiple complaints already about the > size of the stats file for databases with many tables. I don't believe > that it's worth bloating the per-table entries even further with this > information. Tracking reset time it per-database doesn't seem like a > problem though. Is there a reason this info needs to be tracked in the stats table? I know it's the most obvious place, but since we're worriedabout the size of it, what about tracking it in pg_class or somewhere else? -- Jim C. Nasby, Database Architect jim@nasby.net 512.569.9461 (cell) http://jim.nasby.net
В списке pgsql-hackers по дате отправления: