Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: depesz(at)depesz(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Date: 2016-06-13 12:56:56
Message-ID: 41f45186-64f6-8f9a-c72a-a3e9555d57b1@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 6/9/16 11:46 AM, hubert depesz lubaczewski wrote:
> Basically it looks that postgresql "caches" query plans? parsed elements? for
> queries, but doesn't put any kind of limit to size of this cache. Which means
> that if our app is using LOTS of different queries, the memory usage will grow
> in time.

If you compile with -DSHOW_MEMORY_STATS, it will print out memory
allocation after every command, so you might be able to see where the
memory is going.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hubert depesz lubaczewski 2016-06-13 13:22:17 Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Previous Message hubert depesz lubaczewski 2016-06-13 09:39:07 Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables