Fwd: Memory usage after upgrade to 9.2.4

And this one only to Adrian.

Sorry to all.

---------- Forwarded message ----------
From: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
Date: 2013/4/20
Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

2013/4/20 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

> On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote:
>
>>
>>
>>
>> 2013/4/20 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com
>> <mailto:adrian(dot)klaver(at)gmail(dot)**com <adrian(dot)klaver(at)gmail(dot)com>>>
>>
>>
>> On 04/20/2013 04:08 PM, Daniel Cristian Cruz wrote:
>>
>> I think I didn't make it clear: the session memory usage is
>> growing up
>> too fast, until all server memory got used and swap occurs.
>>
>> Never saw something like that. The version is under a test
>> enviroment
>> for a long time...
>>
>> Thanks if someone could help me.
>>
>>
>> Before any one can help I would think more information is needed;
>>
>> 1) Is it on the same machine/OS as the old version?
>>
>>
>> Yes same machine, CentOS 5.5, just upgraded PostgreSQL only
>>
>
> How did you upgrade?
> pg_upgrade
> dump/restore

pg_upgrade

>
>
>
>> 4) You seem to imply that in test mode everything worked alright, is
>> that the case?
>>
>>
>> Yes, got two servers, never got the same issue
>>
>
> So what difference is there between the test and production servers?

A real server, two VMs with very less memory and CPUs

>
>
>
>>
>> 5) In either case, test/production, what is being done in the
>> session(s)?
>>
>>
>> Some complex queries. Some very complex queries...
>>
>
> Any chance to see an EXPLAIN ANALYZE for query on test machine vs
> production?
>

Right now I'm building a tool to import the loose records from the new
version to the old, since I'm doing a rollback over the upgrade. As soon I
finish it, I could debug what is happening in the cluster.

>
>
>
>>
>>
>>
>>
>> --
>> Daniel Cristian Cruz
>> クルズ クリスチアン ダニエル
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)gmail(dot)com <mailto:adrian(dot)klaver(at)gmail(dot)**com<adrian(dot)klaver(at)gmail(dot)com>
>> >
>>
>>
>>
>>
>>
>> --
>> Daniel Cristian Cruz
>> クルズ クリスチアン ダニエル
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル

--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル