Re: ERROR: could not resize shared memory segment...No space left on device

2019-12-16 Thread Thomas Munro
On Tue, Dec 17, 2019 at 10:53 AM Tomas Vondra wrote: > Interestingly enough, I ran into the same ERROR (not sure if the same > root cause) while investigating bug #16104 [1], i.e. on a much simpler > query (single join). > > This This particular machine is a bit smaller (only 8GB of RAM and less >

Re: ERROR: could not resize shared memory segment...No space left on device

2019-12-16 Thread Tomas Vondra
On Mon, Dec 16, 2019 at 12:49:06PM -0600, Justin Pryzby wrote: A customer's report query hit this error. ERROR: could not resize shared memory segment "/PostgreSQL.2011322019" to 134217728 bytes: No space left on device I found: https://www.postgresql.org/message-id/flat/CAEepm%3D2D_JGb8X%3DLa