On 04/20/2013 05:19 PM, Daniel Cristian Cruz wrote: Copying to list to fill in blanks.
2013/4/20 Adrian Klaver <adrian.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx>> On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote: 2013/4/20 Adrian Klaver <adrian.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx> <mailto:adrian.klaver@gmail.__com <mailto:adrian.klaver@xxxxxxxxx>>> 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.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx> <mailto:adrian.klaver@gmail.__com <mailto:adrian.klaver@xxxxxxxxx>> -- Daniel Cristian Cruz クルズ クリスチアン ダニエル -- Adrian Klaver adrian.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx> -- Daniel Cristian Cruz クルズ クリスチアン ダニエル
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
