Archive for May 31, 2005

Fitness Resolution

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

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

To find out what filedescriptors or sockets are used by a particular application, you can run...

sockstat -u

Method to cleanly DROP FUNCTIONs by wildcard in Postgres

Cut and paste the output of this execution:


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