- Dec 28, 2020
-
-
Dan Notestein authored
Added/modified indexes for hive_posts and hive_feed_cache to speed up queries See merge request !452
-
Bartek Wrona authored
- supplemented list of indexes to be disabled at massive sync - supplemented upgrade scripts - WIP: upgrade still needs to be tested on prod. database
-
Jason Salyers authored
-
Dan Notestein authored
[DLN] added/modified some indexes to increase performance (to hive_posts and hive_feed_cache tables)
-
Dan Notestein authored
Eliminate 7 day vote check "optimization" and always use full vote history to compute latest vote because it can be computed with an index-only scan (when the account hasn't voted in last 7 days, this is about 100x faster compare to the 7 day check and is just as fast even when account has voted very recently). This should dramatically lower the load on hivemind.
-
- Dec 25, 2020
-
-
Dan Notestein authored
-
Dan Notestein authored
Replace in operator by join to optimize some cases, but this will make query slow in other cases until the followup commit where we change the hive_posts_author_id_created_at_idx and hive_posts_parent_id_idx indexes to allow for index-only-scans.
-
- Dec 22, 2020
-
-
Bartek Wrona authored
Cleanup in `Mutes` class See merge request !448
-
Bartek Wrona authored
follow notification time fix See merge request !449
-
Marcin authored
-
Bartek Wrona authored
-
- Dec 21, 2020
-
-
Bartek Wrona authored
-
Bartek Wrona authored
-
Mariusz Trela authored
-
- Dec 18, 2020
-
-
Bartek Wrona authored
Added hive_notification_cache table supplement (autoincrement definition for id column). See merge request !447
-
Bartek Wrona authored
-
Bartek Wrona authored
-
Bartek Wrona authored
notification cache use autoincrement id See merge request !445
-
-
- Dec 17, 2020
-
-
Bartek Wrona authored
-
Bartek Wrona authored
-
-
Bartek Wrona authored
-
Bartek Wrona authored
-
Marcin authored
-
Bartek Wrona authored
Another temp. fix related to ID generation. See merge request !444
-
Bartek Wrona authored
-
Bartek Wrona authored
notification id generation fix See merge request !443
-
Bartek Wrona authored
-
- Dec 15, 2020
-
-
Bartek Wrona authored
- Fixed bug causing to leave all old reputation data (which shall be truncated) See merge request !439
-
Bartek Wrona authored
Fixes in get_discussions_by_feed See merge request !438
-
Bartek Wrona authored
-
Bartek Wrona authored
- After creating indexes ANALYZE statement is called automatically - db_upgrade performs an VACUUM FULL ANALYZE spawn if needed - update procedures notify about their execution
-
Andrzej Lisak authored
-
Andrzej Lisak authored
Merge branch 'abw_get_discussions_by_feed_fixes' of gitlab.syncad.com:hive/hivemind into abw_get_discussions_by_feed_fixes
-
Andrzej Lisak authored
[ABW]: fexed validation of author in bridge.get_account_posts/feed and condenser_api.get_discussions_by_feed also pages no longer overlap in those calls
-
Dan Notestein authored
-
Dan Notestein authored
-
- Dec 14, 2020
-
-
Dan Notestein authored
Optimize bridge_get_account_posts_by_replies by moving "ORDER BY ar.id DESC" out of inner query so that optimizer doesn't think it should do a sequential scan of hive_posts (the LIMIT + ORDER BY seems to have led it astray). Previous code was too slow when the author didn't have any posts that could be replied to.
-
- Dec 11, 2020
-
-
Bartek Wrona authored
get account posts by replies perf fix See merge request !432
-