# Spatial 데이터를 1만배 잘 다루게 된 방법

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

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=3671](https://news.hada.io/topic?id=3671)
- GeekNews Markdown: [https://news.hada.io/topic/3671.md](https://news.hada.io/topic/3671.md)
- Type: news
- Author: [smartbosslee](https://news.hada.io/@smartbosslee)
- Published: 2021-02-02T10:44:24+09:00
- Updated: 2021-02-02T10:44:24+09:00
- Original source: [mesh.dev](https://mesh.dev/20210120-dev-note-001-spatial-data/)
- Points: 11
- Comments: 0

## Topic Body

- Postgres가 R-Tree 인덱스를 활용하지 않고 풀스캔하는 경우가 있음

- R-Tree 인덱스를 적용하기 좋게 Materialized View를 활용해서 성능을 개선 함

## Comments



_No public comments on this page._