# PG12에서 손상된 인덱스, 어떻게 수정하나요?

**URL:** https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570
**Category:** Self-hosting
**Created:** [5월 25, 2020, 2:45오전 UTC](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570 "2020-05-25T02:45:43Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)
#### Post date: [5월 25, 2020, 3:02오전 UTC](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570/5 "2020-05-25T03:02:29Z")

</div>

네, 이 문제를 해결하기 위해 그에게 이메일을 보내겠습니다 🙂

참고: 데이터 탐색기에서 SQL을 실행했을 때 다음과 같은 결과가 나왔습니다.

| id | name | topic\_count | created\_at | updated\_at | pm\_topic\_count | target\_tag |
| --- | --- | --- | --- | --- | --- | --- |
| 1710 | chronicillness | 2 | 2019-12-03T17:49:17.395Z | 2019-12-03T17:49:17.395Z | 0 | NULL |

다음처럼 하면

```plaintext
Tag.find_by(id: 1710).destroy

```

해결될까요?

---

_[View the full topic](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570)._