|
|
|
|
|
|
by sehrope
4244 days ago
|
|
|
This is pretty neat. I'm a big fan of SQL in general and being able to query system stats like this feels pretty natural to me. A long time back I created something similar to this atop Oracle[1]. It used a Java function calling out to system functions to get similar data sets (I/O usage, memory usage, etc). It was definitely a hack, but a really pleasant one to use. Be cool to see an foreign data wrapper for PostgreSQL[2] that exposes similar functionality. I'm guessing it'd be pretty easy to put together as you'd only need to expose the data sets themselves as set returning functions. PostgreSQL would handle the rest. Though I guess that would limit it's usefulness to servers that have PG already installed. Having it be separate like this let's you drop it on any server (looks like it's cross platform too!). [1]: I don't remember exactly when but I think 10g had just been released. [2]: http://www.postgresql.org/docs/9.3/static/postgres-fdw.html |
|
|
Well, the announcement says its cross-platform because it runs on two flavors of Linux (Ubuntu and CentOS) and on Max OSX.