Search Postgresql Archives

Re: Memory usage after upgrade to 9.2.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 21.4.2013 15:14, Tom Lane wrote:
> Tomas Vondra <tv@xxxxxxxx> writes:
>> I do have a log with the memory context info printed after the OOM
>> killed the session - see it attached.
> 
> The only thing that seems rather bloated is the CacheMemoryContext,
> which seems to be because the backend has cached info about several
> thousand tables and indexes.  Given that you say there's 9500 relations
> in their schema, it's hard to believe that 9.2.4 is suddenly doing that
> where 9.2.3 didn't.  I'm wondering if they've done something else that
> restricted the amount of memory available to a backend.

My thoughts, exactly. I can't really compare the CacheMemoryContext to
the 9.1.3, as I have no data from that version. So maybe it really did
not change, but something else obviously did.

I'm not aware of any other changes, but I'll verify that.

Tomas


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux