[21:24] <soultcer> chronomex: Would this work as db design? http://pastebin.com/afKdmUBt
[21:25] <soultcer> I wanna try importing a couple million records into a postgres db to see what happens
[21:26] <soultcer> Maybe partitioning ( http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html ) of the shorturl table would be a good idea, putting all bit.ly links on one table, all tinyurl.com links in one and all the smaller shorteners into another table
[22:50] <chronomex> you could cluster instead