Re: PostgreSQL memory usage - Mailing list pgsql-general

From Laurenz Albe
Subject Re: PostgreSQL memory usage
Date
Msg-id 9d662d4588db8f77f8bb2c9bab360f77021aadc5.camel@cybertec.at
Whole thread Raw
In response to PostgreSQL memory usage  (Alexander Pyhalov <alp@sfedu.ru>)
Responses RE: PostgreSQL memory usage
List pgsql-general
Alexander Pyhalov wrote:
> After looking at my DBMS server for some time I've understood that I don't understand what was going on...
> 
> A server has 48 GB RAM. shared_buffers is set to 12GB, work_mem - to 32MB, pgbouncer
> in transaction mode is used to connect pool (pool size 80) to PostgreSQL 10.5 server. 
> 
> I see that at some point several postgresql backends start consuming about 16  GB RAM.
> If we account for shared_buffers, it meens 4 GB RAM for private backend memory.
> How can we achieve such numbers? I don't see any long-running (or complex) queries
> (however, there could be long-running transactions and queries to large partitioned tables).
> But how could they consume 512* work_mem memory?

A wild guess: you are using large data items, or you have PostGIS installed,
which is known to use lots of memory for certain operations, which is not
limited by "work_mem".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: David Steele
Date:
Subject: Re: pgbackrest with PAF(corosync and pacmaker)
Next
From: M Tarkeshwar Rao
Date:
Subject: Can you please tell us how set this prefetch attribute in followinglines.