While extracting parcel IDs from property descriptions, I've ran into issues with shared memory.
Default Settings
There are default settings, note how much memory docker allocates to shared memory, immediately you'll see postgreses defaults don't even fit in that.
Docker
Increase Shared memory, from 64mb
Postgres
Shared buffer, defaults to 128mb (see shared_buffers)
Temp buffer, defaults to 8mb (see temp_buffers)
Work memory, defaults to 4mb (see work_mem)
Lets increase the docker container memory specs to be inclusion of whatever happening in the database, then from there tweak them in unison if Postgreses own settings need modification.
AKST
commented
2 weeks ago
While extracting parcel IDs from property descriptions, I've ran into issues with shared memory.
Default Settings
There are default settings, note how much memory docker allocates to shared memory, immediately you'll see postgreses defaults don't even fit in that.
64mb128mb(seeshared_buffers)8mb(seetemp_buffers)4mb(seework_mem)Lets increase the docker container memory specs to be inclusion of whatever happening in the database, then from there tweak them in unison if Postgreses own settings need modification.