my life

day to day

Archive for May, 2005

Fitness Resolution

Tuesday, May 31st, 2005

By June 30th, I will be able to maintain a heart rate of 154 bpm for 45 minutes. I commit to myself that I will attend the Gym no less than 4 times a week until this resolution is met.

Status:
May 31 - 10 Minutes; 130 HR; 82 RPM
June 1 - 20 Minutes; 154 HR; 82 RPM
June 2 - 25 Minutes; 164 HR; 85 RPM
June 6 - 25 Minutes; 174 HR; 93 RPM

add to del.icio.us    add to technorati favs   email this

Posted in journal | No Comments »

Find out the fd that are in use and by what.

Monday, May 30th, 2005
To find out what filedescriptors or sockets are used by a particular application, you can run...

sockstat -u

Posted in HOWTO | No Comments »

Method to cleanly DROP FUNCTIONs by wildcard in Postgres

Monday, May 30th, 2005

Cut and paste the output of this execution:


SELECT 'DROP function ' || proname || ' ('|| oidvectortypes(proargtypes) || ') CASCADE;' from pg_proc WHERE proname ~ '^create_product$';

Posted in HOWTO | No Comments »