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

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