# 건강한 Postgres DB를 위한 팁

> Clean Markdown view of GeekNews topic #5721. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=5721](https://news.hada.io/topic?id=5721)
- GeekNews Markdown: [https://news.hada.io/topic/5721.md](https://news.hada.io/topic/5721.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2022-01-11T09:35:49+09:00
- Updated: 2022-01-11T09:35:49+09:00
- Original source: [blog.crunchydata.com](https://blog.crunchydata.com/blog/five-tips-for-a-healthier-postgres-database-in-the-new-year)
- Points: 16
- Comments: 0

## Topic Body

- 쿼리 타임아웃 설정 : statement_timeout = '60s'

- pg_stat_statements 확장 설치해서 쿼리 추적 활성화

- 느린 쿼리 로깅 : log_min_duration_statement 을 1s / 100ms 로 지정

- PgBouncer 로 커넥션 관리 개선

- 인덱스의 골디락스 범위 찾기 (별도 글 링크)

## Comments



_No public comments on this page._