db_shared_buffers(총 RAM의 0.1%)와 db_work_mem(총 RAM의 0.03%) 값을 늘릴 수 없습니다

[markersocial]

@pfaffman

RAM이 아니라 하드 드라이브 공간을 의미합니다.

@pfaffman 감사합니다. 처음에는 저도 그렇게 생각했지만, 이 스레드를 읽게 되었습니다:

PG throws could not resize shared memory segment error

After upgrading (with ‘launcher rebuild app’ times two) to Postgres 10, we’ve started seeing errors like this in /logs: Failed to handle exception in exception app middleware : PG::DiskFull: ERROR: could not resize shared memory segment "/PostgreSQL.682207201" to 283432 bytes: No space left on device : SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, … Ideas? Looks like PG is unable to increase the size of a shared memory segment, can this be tuned …

여기에도 사용 가능한 공간이 많이 있습니다