smellman

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

Taro's vm on mac

spec

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

results

smellman

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

<!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

# 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

smellman

====> : Start SQL postprocessing:  ./build/sql/* -> PostgreSQL 
      : Source code: https://github.com/openmaptiles/openmaptiles-tools/blob/master/bin/import-sql
Starting postgres docker compose target using default image (no recreate if exists)
Starting openmaptiles_postgres_1 ... done
docker-compose run --rm -u 1000:1000 openmaptiles-tools sh -c 'pgwait && import-sql' | \
  awk -v s=": WARNING:" '$0~s{print; print "\n*** WARNING detected, aborting"; exit(1)} 1'
Importing /usr/src/app/sql/CleanNumeric.sql (md5 d8300fc8b346b6288993391fb4f3c31d  -  18 lines) into Postgres...
Timing is on.
CREATE FUNCTION
Time: 11.222 ms

smellman

smellman

FROM sphinxdoc/sphinx-latexpdf

WORKDIR /docs

RUN mkdir -p /usr/share/man/man1

RUN apt-get update \
  && apt-get install -y \
  default-jre \
  && apt-get autoremove \

smellman

# DB Version: 12
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 16 GB
# CPUs num: 12
# Connections num: 100
# Data Storage: ssd

max_connections = 100
shared_buffers = 4GB

smellman