smellman

# This file defines default environment variables for all images

# Layers definition and meta data
TILESET_FILE=openmaptiles.yaml

# Use 3-part patch version to ignore patch updates, e.g. 5.0.0
TOOLS_VERSION=5.3

# Make sure these values are in sync with the ones in .env-postgres file
PGDATABASE=openmaptiles

smellman

ffmpeg -thread_queue_size 512 -f alsa -i hw:2,0 -f v4l2 -s 1280x720 -i /dev/video1 -vcodec libx264 -pix_fmt yuv420p -preset ultrafast -g 20 -b:v 2000k -acodec aac -b:a 128k -threads 0 -f flv rtmp://a.rtmp.youtube.com/live2/xxxxxxxxxxx

smellman

FROM pandoc/latex:2.14.0.3

ARG eisvogel_version=2.0.0

RUN tlmgr install luatexja
RUN tlmgr install haranoaji haranoaji-extra
RUN tlmgr install adjustbox babel-german background bidi collectbox csquotes everypage filehook footmisc footnotebackref framed fvextra letltxmacro ly1 mdframed mweights needspace pagecolor sourcecodepro sourcesanspro titling ucharcat ulem unicode-math upquote xecjk xurl zref || exit 1
RUN tlmgr install selnolig || exit 1

RUN mkdir -p /templates/eisvogel \

smellman

smellman

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

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

```
+    # 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

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

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