On 04/20/2013 04:30 PM, Daniel Cristian Cruz wrote:
2013/4/20 Adrian Klaver <adrian.klaver@xxxxxxxxx
<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
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.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
