About

Sangwook (Shawn) Kim is a co-founder and CEO at Apposha, which is building PostgreSQL extension for scalable file I/O. Before founding Apposha, Sangwook worked at Computer Systems Laboratory in Sunkyunkwan University. His main work was developing operating system-level techniques for database performance. Specifically, Sangwook has over 9 years experience in analyzing and optimizing Linux kernel for open source databases including PostgreSQL, MongoDB, MySQL, and Redis.

He spoke at various PostgreSQL Conferences in the past including -

PGDay Seoul - 2017

PGConf Asia - 2017

PGDay Seoul - 2018

PGConf Asia - 2019

Postgres Conference Silicon Valley - 2019

PGDay Seoul - 2019

PGConf Russia - 2020

---

Sangwook Kim has presented the following presentations

Make Your PostgreSQL 10x Faster on Cloud in Minutes at Postgres Conference 2020
PostgreSQL extension for cloud-native file I/O
presented by Sangwook Kim and Byeonghun Hyeon
Cloud storage has some unique characteristics compared to traditional storage mainly because it is virtualized and controlled by software. One example is that AWS EBS shows higher throughput with larger I/O size up to 256 KiB without hurting latency. Hence, a user can get only about 4 MiB/sec with 1,000 IOPS EBS volume if the I/O request size is 4 KiB, whereas a user can get about 250 MiB/sec...
more
Ops and Administration
Taming Performance Variability in PostgreSQL at Silicon Valley 2019
How to make PostgreSQL responsive and predictable for write-intensive workloads
presented by Sangwook Kim
PostgreSQL background tasks, such as the checkpointer and autovacuum workers, produce file I/O in bursts. This behavior is increased in write-intensive workloads. These background tasks are essential to guarantee the ACID properties while providing high performance, however, they significantly affect performance variability. In our experiments with write-intensive OLTP queries, tuning the check...
more
Fri 20 2019 Ops and Administration