Document that high db pool size requires increased shared memory for postgres about lemmy-docs HOT 4 OPEN

could not resize shared memory segment "/PostgreSQL.1513506408" is a problem with shared memory (/dev/shm) not disk space. Is postgres constrained in the amount of shared memory it can use, or is there only a small amount on the server?

from lemmy-docs.

df -h shows this (same if executed inside the postgres docker container):

tmpfs            16G     0   16G   0% /dev/shm

Also it looks like lowering db pool size really did fix the issue.

from lemmy-docs.

It's a bit old but have a look at the docker settings: https://stackoverflow.com/questions/56751565/pq-could-not-resize-shared-memory-segment-no-space-left-on-device

from lemmy-docs.

Thanks, that works! I added the following to docker-compose.yml as suggested in the stackoverflow link.

postgres:
    image: postgres:15-alpine
    shm_size: 1g
    ...

Gonna move this to the docs repo.

from lemmy-docs.