Skip to content

Instantly share code, notes, and snippets.

View smellman's full-sized avatar

Taro Matsuzawa aka. btm smellman

141 followers · 9 following
View GitHub Profile
@smellman
smellman / test.geojson
Last active March 27, 2021 05:59
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / Dockerfile
Created December 18, 2020 07:27
Py3dtiles dockerfile
FROM ubuntu:20.10
LABEL maintainer="Taro Matsuzawa ([email protected])"
WORKDIR /
RUN set -ex \
&& apt-get update \
&& apt-get install -y --no-install-recommends \
python3 \
python3-pip \
@smellman
smellman / Dockerfile
Created December 16, 2020 05:52
Potree 1.7 Dockerfile
FROM ubuntu:bionic
ENV DEBIAN_FRONTEND=noninteractive
RUN apt-get update && apt-get install -y --no-install-recommends g++-8 git build-essential cmake make ca-certificates \
&& rm -rf /var/lib/apt/lists/*
# gcc-8 is required for new c++17 headers used in Potree Converter
RUN update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-8 800 --slave /usr/bin/g++ g++ /usr/bin/g++-8
RUN mkdir /data
@smellman
smellman / omt_benchmark.txt
Last active February 6, 2021 11:16
OpenMapTiles Bench Mark
```
+ # pgtune + dw
+ command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=500 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=26214kB -c min_wal_size=4GB -c max_wal_size=16GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + oltp
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=100 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=52428kB -c min_wal_size=2GB -c max_wal_size=8GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + web
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.7 -c wal_buff
@smellman
smellman / 0001-supports-proj-changes-update-mercator-projection.patch
Created November 6, 2020 11:01
0001-supports-proj-changes-update-mercator-projection.patch
From cb83398706df33b08242e66714608c66e7d6b8e4 Mon Sep 17 00:00:00 2001
From: Taro Matsuzawa <[email protected]>
Date: Fri, 6 Nov 2020 19:58:53 +0900
Subject: [PATCH] supports proj changes: update mercator projection
---
regress/core/tickets.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
@smellman
smellman / postgresql-tuning-docker.md
Created September 10, 2020 00:43

PostgreSQL tuning via https://pgtune.leopard.in.ua/

# DB Version: 9.6
# OS Type: linux
# DB Type: dw
# Total Memory (RAM): 32 GB
# CPUs num: 8
# Data Storage: ssd
@smellman
smellman / openmaptiles-benchmark.md
Last active September 23, 2020 10:44
OpenMapTiles benchmark

Taro's vm on mac

spec

  • macbook pro 2018 + pararell desktop pro
  • 8 cpu
  • 16GB Memory
  • Ubuntu 20.04

results

@smellman
smellman / eduke32_error_position.diff
Created September 6, 2020 06:00
Eduke32 error position
diff --git a/source/duke3d/src/common.cpp b/source/duke3d/src/common.cpp
index d269f526f..41ef06dab 100644
--- a/source/duke3d/src/common.cpp
+++ b/source/duke3d/src/common.cpp
@@ -255,12 +255,13 @@ void G_ExtPreInit(int32_t argc,char const * const * argv)
void G_ExtInit(void)
{
+/*
#ifdef EDUKE32_OSX
@smellman
smellman / index.html
Created August 23, 2020 06:40
Kakegawa Castle on Cesium
<!DOCTYPE html>
<html>
　<head>
　　<meta charset="UTF-8">
　　<title>Kakegawa Castle on Cesium</title>
　　<script src="https://cesium.com/downloads/cesiumjs/releases/1.72/Build/Cesium/Cesium.js"></script>
　<link href="https://cesium.com/downloads/cesiumjs/releases/1.72/Build/Cesium/Widgets/widgets.css" rel="stylesheet">
<style>
#cesiumContainer {
@smellman
smellman / entwine_memo.txt
Created August 20, 2020 11:01
# shizuoka data convert to cesium data
docker run -it -v $(pwd):/entwine connormanning/entwine build -i /entwine/kakegawa.las -o /entwine/entwine -r EPSG:2444 EPSG:4978
ept tile -i entwine -o cesium/
cd cesium/kakegawa
npx serve -C