And this one only to Adrian. Sorry to all.
---------- Forwarded message ---------- From: Daniel Cristian Cruz <danielcrist...@gmail.com> Date: 2013/4/20 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Adrian Klaver <adrian.kla...@gmail.com> 2013/4/20 Adrian Klaver <adrian.kla...@gmail.com> > On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote: > >> >> >> >> 2013/4/20 Adrian Klaver <adrian.kla...@gmail.com >> <mailto:adrian.klaver@gmail.**com <adrian.kla...@gmail.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.kla...@gmail.com >> <mailto:adrian.klaver@gmail.**com<adrian.kla...@gmail.com> >> > >> >> >> >> >> >> -- >> Daniel Cristian Cruz >> クルズ クリスチアン ダニエル >> > > > -- > Adrian Klaver > adrian.kla...@gmail.com > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル -- Daniel Cristian Cruz クルズ クリスチアン ダニエル