2020-11-19 20시 개발자 글 모음 | "Spatial data를 10,000"

Spatial data를 10,000배 잘 다루는 방법 by 강성일

• 659 rows=2526 loops=2) Recheck Cond: ((address_type)::text = 'LEGAL'::text) Heap Blocks: exact=107 -> Bitmap Index Scan on address_address_type_index (cost=0
• 710 rows=5504 loops=1) Index Cond: ((address_type)::text = 'LEGAL'::text) -> Index Only Scan using address_polygon_pkey on address_polygon (cost=0
• 003 rows=5048 loops=1) Index Cond: ((address_type)::text = 'LEGAL'::text) -> Index Scan using region_primary_key on region (cost=0

---