Fwd: Query error: could not resize shared memory segment

From: Thuc Nguyen Canh <thucnguyencanh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Fwd: Query error: could not resize shared memory segment
Date: 2018-01-03 00:22:03
Message-ID: CAG903PrStVFsFbh02MrANe0M6wgFGwf_mzVcd+ZeL-D57QOggQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I got following error when running some heavy queries
"ERROR: could not resize shared memory segment "/PostgreSQL.388782411" to
50438144 bytes: No space left on device SQL state: 53100"

I'm using a postgis 10 docker container with mounted volume on ubuntu 16
vps.

Some of failed queries can run after I increased my work_mem.

On the other hand, this issue is not producible on postgresql 9.6.

Hope to get any advice here.

Thanks and regards,

Thuc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jordan Deitch 2018-01-03 02:45:36 Mailing list archiver
Previous Message James Keener 2018-01-02 23:33:54 Re: Need information on the tools available to upload the shape files to the postgreSQL database