sadfuzzy

-- View Current Lock
SELECT c.relname, l.mode, l.granted, l.pid FROM pg_locks as l JOIN pg_class as c on c.oid = l.relation;

-- UTF-8 text search by index
create index on <table> (<column> text_pattern_ops);

-- Generate nodes path
create table <table> as select i, format('/%s/%s/', (random() * 10), (random() * 10)) from generate_series(1,100000);

-- Create extension

sadfuzzy

iTerm2 – Useful Shortcuts (Mac OS X)

with a hat tip to Sublime Text 2 Shortcuts

The Awesome

⌘;	autocomplete
⌘⌥B	instant replay
⌘⌥E	search across all tabs

sadfuzzy

Prepare

Remove RVM

rvm implode

Ensure your homebrew is working properly and up to date

brew doctor