As part of a new and fairly large project I have a need to partition a few postgres tables and have a rolling daily window. That is.. I want to organize data by a timestamp storing each day in its own partition and maintain 90 days of historical data. Doing this is possible in Postgresql [...]
Browsing Posts in Geeky Stuff
What I do – Dynamic Daily Table Partitions With Postgres
January 19, 2012
No comments
OSX Mail App Using Tons of Memory and CPU?
January 7, 2012
No comments
I’ve been using a mac for a while now and I recently decided to dump Entourage and go to using the native Mail.app. I noticed a problem though.. within minutes of starting up it would consume several hundred megs of ram and have frequent CPU spikes of 80 to 100%. If Mail was left open, [...]
What I do – Interviewing for Linux Engineers
December 11, 2011
No comments
Now and then I’m called on to help interview candidates for linux admin/engineer slots and as I’ve been doing some of that lately I thought I’d share the way I go about doing a technical interview. This approach seems to work equally well over the phone or in person. I’m big on understanding the fundamentals [...]
What I do – Voice Integration With Nagios and Asterisk
December 5, 2011
No comments
I was called on to provide a method of alerting from within nagios that was more active and direct than the usual use of email or SMS messages. So I came up with a simple way to have a nagios notification place a phone call to our off hours tier3 support line to report certain [...]
Sketchy Things From China – ‘Apple’ Power Supply
November 14, 2011
No comments
As part of a new project I needed a power connector for a macbook. Not wanting to shell out $65 for an official power supply just for the connector I picked one up from ebay for about $20. On first glance this looks like an apple power supply.. but something just seemed off about it. [...]
