PostGIS high memory consumption
skanuddel
PROOP

a year ago

I created a PostGIS database and uploaded all my data (~20GB). Now the memory consumption is almost as high as the volume consumption.

The shared_buffers is set to 128mb, work_mem to 4mb and maintenance_work_mem to 64mb.

Do I need to assign less RAM to the PostGIS to tackle this issue? Is the PostGIS caching on OS-level or why do I even have this issue?

Solved

1 Replies

angelo-railway
EMPLOYEE

a year ago

PostGIS likes to cache agressively, you can try assigning less RAM.

Status changed to Awaiting User Response Railway • 11 months ago

Railway
BOT

7 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway • 7 months ago

Loading...