user:thomas gists created by user
user:thomas
title:mygist gists with given title
title:mygist
filename:myfile.txt gists having files with given name
filename:myfile.txt
extension:yml gists having files with given extension
extension:yml
language:go gists having files with given language
language:go
topic:homelab gists with given topic
topic:homelab
Register
Login
Joined 1750840855
gdalbuildvrt "C:\ujsky\source_all.vrt" "D:\uj_2026\*.tif"
gdalwarp -s_srs EPSG:5187 -t_srs EPSG:3857 -of VRT ^ "C:\ujsky\source_all.vrt" "C:\ujsky\merged_3857.vrt"
1️⃣ StartServers / SpareThreads 조정
현재 설정:
StartServers 2 MinSpareThreads 25 MaxSpareThreads 75 개선 제안
StartServers 5~10 → 초기 idle worker 충분히 확보
psql -h localhost -U postgres -d dadgis \ -c "\COPY (SELECT * FROM public.zzz_forest_info_51760) TO './forest_51760.csv' CSV"
데이터 건수 : 557,918 건
45.5GB TIF 파일
/etc/postgresql/16/main
sudo systemctl reload [email protected]
GIS에서 가장 많이 쓰이는 전통적 방식이에요.
Shapefile (.shp, .shx, .dbf, …)
Powered by Opengist ⋅ Load: 971ms⋅