Re: Memory usage after upgrade to 9.2.4

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>>
>
> 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

>
> 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?

>
>
> 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?

>
>
>
>
>
> --
> 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