postgres container uses only one cpu

Drew

2/22/23, 2:27 PM

I'm doing a lot of SQL inserts and the limiting factor appears to be CPU assigned to postgres. Most of these inserts are to the same table. I'm a bit confused here as I'm using docker-compose with no resource limits, the container should use all available 16 cores.

inside container

:/# nproc
16
:/# postgres --version
postgres (PostgreSQL) 13.4 (Debian 13.4-1.pgdg100+1)

Here's my postgres config

# Default stuff
listen_addresses = '*'

# DB Version: 13
# OS Type: linux
# DB Type: oltp
# Total Memory (RAM): 32 GB
# CPUs num: 12
# Connections num: 50
# Data Storage: ssd

max_connections = 50
shared_buffers = 8GB
effective_cache_size = 24GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 41943kB
min_wal_size = 2GB
max_wal_size = 8GB
max_worker_processes = 12
max_parallel_workers_per_gather = 4
max_parallel_workers = 12
max_parallel_maintenance_workers = 4

150

0 + 0

postgresql

docker

docker-compose

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: postgres container uses only one cpu

TH: คอนเทนเนอร์ postgres ใช้ซีพียูเพียงตัวเดียว

RO: Containerul postgres folosește doar un singur procesor

RU: Контейнер postgres использует только один процессор

VI: thùng chứa postgres chỉ sử dụng một cpu

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.