mirror of
https://github.com/LemmyNet/lemmy.git
synced 2025-09-02 03:03:57 +00:00
* Finishing up post and comment actions * Adding community_actions. * instance and person actions * Fixing person_actions. * Fixing down migrations * Adding person_content_combined. * Search combined. * Aggregates tables. * Dont rename old tables * Fixing some constraints. * Convert bigints to ints * Forgot a bigint. * Rest of i64 -> i32 * Adding actions id columns. * Fixing connection config. * Formatting smoosh up.sql * Use current_date instead of now * Adding history tables for liked_combined * Upping wal size * Fix clippy * Fixing clippy. * Fixing i64 * Getting rid of let mut conn * Adding the history status table. * Adding published indexes to speed up history. * Adding comment like history scanning. * Fixing schema options setup. * post_read history * person_post_aggregates / read_comments history * post_like history * Fixing conflicts. * Fixing clippy. * Use constant batch_size. * person content combined post and comment history. * Fixing id scanning. * post/comment_actions -> saved_combined history * search history * Post and comment aggregates -> post / comment history. * Uncommenting full history building. * Changing DB_BATCH_SIZE to i64 * Fixing clippy. * Fix index names. * Fixing diff check by removing indexes. * Adding the uplete ignore actions::id columns. * Fixing merge imports. * Fixing submodule update * Try trigger disabling. * Fix clippy * Remove history table, do faster bulk inserts. Smoosh first. Comments about how this fast insert is done is within smoosh comments. * Adding some timings. * Fast person content combined history * Adding search_combined * Fix person saved combined unique names * person_liked_combined * Remove-aggregates * Fixing up.sql issues * Re-building schema.rs * Fixing down migrations. * Removing history updating. * Format sql. * Move postgres logging to customPostgresql.conf * Try using postgres 16-alpine in CI * Speeding up add_report_count. * speed up inbox_combined * Speeding up remove_post_sort_type_enums * Fixing post_sort_type * Speeding up person votes * Fixing wrong conn. * Fixing broken migrations * Remove comment. * Make sure to re-index table after re-enabling indexes. * Removing id columns from actions tables. * Fixing down migrations. * Using create table as for smoosh migration * create_table as for person_content_combined. * Fixing person_content_combined uniques * create table as for search_combined * create table as for liked_combined * create table as for inbox_combined. * Fixing a few score types. * Fixing id positions. |
||
---|---|---|
.. | ||
views_old | ||
views_to_diesel_migration | ||
apache_bench_report.sh | ||
api_benchmark.sh | ||
bulk_upsert_timings.md | ||
post_query_hot_rank.sh |