lemmy/migrations/2025-08-01-000030_optimize_get_random_community/down.sql

ALTER TABLE community
    DROP COLUMN random_number;

DROP FUNCTION random_smallint;
Changes to get_random_community_id: add filters for nsfw and private, use algorthm that doesn't scan the entire table (#5267) * get_random_community_id: add filters for nsfw and private, use algorithm that doesn't scan the entire table * only call random_smallint once for filter * change migration date * make random_smallint function work in postgresql 16 * replace "32768 + 32767 + 1" with "65536" and improve comments --------- Co-authored-by: Dessalines <dessalines@users.noreply.github.com> 2025-01-16 19:16:57 +00:00			`ALTER TABLE community`
			`DROP COLUMN random_number;`

			`DROP FUNCTION random_smallint;`