Condenser

Prevent duplicate requests when list_all_subscriptions times out.

PR 3965: https://github.com/steemit/condenser/pull/3965

Hivemind

Further alleviate the performance deficiency caused by the disk I/O overhead of the database server.

• Optimize pids_by_blog: Replace NOT IN subquery with NOT EXISTS for better performance
• Optimize pids_by_feed_with_reblog: Pre-fetch start_created_at to avoid nested subquery in HAVING clause, use explicit INNER JOIN
• Add Redis caching to bridge.list_all_subscriptions to reduce database queries for 300s
• Add Redis caching to all get_post_id/_get_post_id functions across modules for 3600s

PR 359: https://github.com/steemit/hivemind/pull/359

Jussi

• Increase the bridge.* API timeout from 3 seconds to 5 seconds.
• Add a 60s cache for the bridge.* API.