Thank you Thomas,
I make it work with extra setting --shm-size=1g in my docker run script.
On Wed, Jan 3, 2018 at 12:16 PM, Thomas Munro
wrote:
> On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh
> wrote:
>> And here is the result from postgres container:
>>
>> mount |
Hi,
Here is the result from host:
mount | grep /dev/shm
=> tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev)
du -hs /dev/shm
=> 0 /dev/shm
df /dev/shm
=>
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs2023252 0 2023252 0% /dev/shm
---
99 rows=40359886 width=64)'
' Merge Cond: (b.week = s.week)'
'-> Sort (cost=1409.33..1448.61 rows=15712 width=16)'
' Sort Key: b.week'
' -> CTE Scan on badorder b (cost=0.00..314.24 rows=15712
width=16)
h=16) (actual time=16257.737..16263.220 rows=13 loops=1)'
'-> Sort (cost=59005.52..60289.88 rows=513746 width=16) (actual
time=17320.506..17320.509 rows=4 loops=1)'
' Sort Key: s.week'
' Sort Method: quicksort Memory
id, I did
reduce the random_page_cost to 1.1, in order to optimize postgresql
performance on SSD (DO uses SSD) and got this issue.
On Wed, Jan 3, 2018 at 10:53 AM, Thomas Munro wrote:
> On Wed, Jan 3, 2018 at 1:22 PM, Thuc Nguyen Canh
> wrote:
> > I got following error when r
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 ca
