I would think it might be more efficient to add a single column to your posts table, 'subscribed' or what have you, and store a serialized array in said column of subscribed user IDs. Then when a new post is submitted, trigger a callback which will run against this array and fire off the necessary emails.