On 18.06.2013 14:27, MauMau wrote:
The cause of the memory increase appears to be CacheMemoryContext. When I attached to postgres with gdb and ran "call MemoryContextStats(TopMemoryContext)" several times, the size of CacheMemoryContext kept increasing.
Hmm. I could repeat this, and it seems that the catcache for pg_statistic accumulates negative cache entries. Those slowly take up the memory.
Seems that we should somehow flush those, when the table is dropped. Not sure how, but I'll take a look.
- Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers