Re: Memory usage after upgrade to 9.2.4

On 04/20/2013 05:19 PM, Daniel Cristian Cruz wrote:

Copying to list to fill in blanks.

>
>
>
> 2013/4/20 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com
> <mailto: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>
> <mailto:adrian(dot)klaver(at)gmail(dot)__com <mailto: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>
> <mailto:adrian(dot)klaver(at)gmail(dot)__com <mailto:adrian(dot)klaver(at)gmail(dot)com>>
>
>
>
>
>
> --
> Daniel Cristian Cruz
> クルズ クリスチアン ダニエル
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com <mailto:adrian(dot)klaver(at)gmail(dot)com>
>
>
>
>
> --
> Daniel Cristian Cruz
> クルズ クリスチアン ダニエル

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com