miteruzo/btrc-hub
1
0
Fork 0
Code Issues 69 Pull Requests 1 Releases Wiki Activity

post_similarities および tag_similarities のマテリアライズド・テーブルのしやぅ変更 #228

New Issue
Closed
opened 2026-01-21 00:37:41 +09:00 by みてるぞ · 0 comments
みてるぞ commented 2026-01-21 00:37:41 +09:00
Owner
Copy Link
Copy Source

以下の変更を行ふ：

  • それぞれ id 列を廃止
  • *_id と target_*_id のペアでユニーク
  • post_id のみで順引きし，逆引きを認めないやぅにする．
  • (post_id, cos) に複合インデクス
  • cos 上位 20 件のみ保持するやぅに
  • Rake 用の RSpec 作る
  • ついでにタグ親子関係適用の際に追加したコントローラ用の RSpec も作っておく
以下の変更を行ふ： - [x] それぞれ `id` 列を廃止 - [x] `*_id` と `target_*_id` のペアでユニーク - [x] `post_id` のみで順引きし，逆引きを認めないやぅにする． - [x] `(post_id, cos)` に複合インデクス - [x] `cos` 上位 20 件のみ保持するやぅに - [x] Rake 用の RSpec 作る - [x] ついでにタグ親子関係適用の際に追加したコントローラ用の RSpec も作っておく
みてるぞ added the area/backendtype/taskP0status/ready labels 2026-01-21 00:37:41 +09:00
みてるぞ referenced this issue from a commit 2026-01-21 03:10:53 +09:00
#228
みてるぞ added status/in-progress and removed status/ready labels 2026-01-21 03:11:17 +09:00
みてるぞ started working 2026-01-21 21:33:21 +09:00
みてるぞ worked for 1h 31min 21s 2026-01-21 23:04:42 +09:00
みてるぞ referenced this issue from a commit 2026-01-22 02:11:53 +09:00
#228
みてるぞ referenced this issue from a commit 2026-01-22 23:12:30 +09:00
#228
みてるぞ added status/review and removed P0status/in-progress labels 2026-01-22 23:26:19 +09:00
みてるぞ removed the status/review label 2026-01-22 23:45:23 +09:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
area/backend
area/frontend
duplicate
invalid
P0
P1
P2
P3
status/blocked
status/in-progress
status/ready
status/review
type/bug
type/enhancement
type/task
wontfix
No Label area/backend type/task
Milestone
No items
No Milestone
Assignees
Clear assignees
miteruzo (みてるぞ)
No Assignees
1 Participants
Notifications
Total Time Spent: 1 hour 31 minutes
みてるぞ
1 hour 31 minutes
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: miteruzo/btrc-hub#228
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?