1. searching for hash strings in postgres

  2. why sub-selects can be faster than inner joins