Re: Configurable Additional Stats
От | Gregory Stark |
---|---|
Тема | Re: Configurable Additional Stats |
Дата | |
Msg-id | 87ir924v2v.fsf@oxford.xeocode.com обсуждение исходный текст |
Ответ на | Re: Configurable Additional Stats ("Simon Riggs" <simon@2ndquadrant.com>) |
Ответы |
Re: Configurable Additional Stats
Re: Configurable Additional Stats |
Список | pgsql-hackers |
"Simon Riggs" <simon@2ndquadrant.com> writes: > 2) Charge-back accounting. Keep track by userid, user group, time of > access etc of all accesses to the system, so we can provide chargeback > facilities to users. You can put your charging rules into the plugin and > have it spit out appropriate chargeback log records, when/if required. > e.g. log a chargeback record every time a transaction touches > 100 > blocks, to keep track of heavy queries but ignore OLTP workloads. Sure, but I think Tom's question is how do you get from the plugin to wherever you want this data to be? There's not much you can do with the data at that point. You would end up having to reconstruct the entire stats collector infrastructure to ship the data you want out via some communication channel and then aggregate it somewhere else. Perhaps your plugin entry point is most useful *alongside* my stats-domain idea. If you wanted to you could write a plugin which set the stats domain based on whatever criteria you want whether that's time-of-day, userid, load on the system, etc. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: