قسم المراجعات يؤدي إلى خطأ 500 في الخادم لمُراجع معين

zogstrip · 12 أكتوبر 2026، 8:52م

وجدت طريقة لتحسين الاستعلام دون استخدام حيلة OFFSET 0

github.com/discourse/discourse

PERF: Check review queue visibility per topic for moderators (#44497)

main ← perf/review-queue-moderator-visibility

merged 08:26AM - 13 Oct 26 UTC

ZogStriP

+95 -30

Previously, the review queue built every visible topic and every private message… a moderator can see as whole-table subqueries (`topic_id IN (...)` and `NOT IN (...)`). On large sites, Postgres scanned millions of posts or rescanned the PM list once per reviewable. `/review` then timed out with a 500 for non-admin moderators (https://meta.discourse.org/t/414526). This change correlates those checks to each reviewable's topic with `EXISTS` / `NOT EXISTS`, so Postgres does index lookups per reviewable, with the same visibility rules. On a 1M topic / 8M post dataset, the count + page queries for a moderator drop from ~10–32s to ~0.5s, and the pending count from ~4.5s to ~50ms.

الموضوع		الردود	مرات العرض
Category Moderators may receive incorrect number of pending reviews Bug category-moderators , review-queue	0	83	7 أغسطس 2026
Feedback on the new Review Queue (2019) Announcements new-feature , review-queue	260	21110	11 مارس 2023
Proposal: Consolidated Review Queue Feature	33	6377	28 مارس 2019
A new review queue layout with all new features Announcements review-queue	43	3008	20 سبتمبر 2026
App/models/topic_tracking_state - `report` - long response times? Development slow-sql	6	1932	26 فبراير 2016

قسم المراجعات يؤدي إلى خطأ 500 في الخادم لمُراجع معين

الموضوعات ذات الصلة