From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | henk de wit <henk53602(at)hotmail(dot)com> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Huge amount of memory consumed during transaction |
Date: | 2007-10-17 20:40:58 |
Message-ID: | 20071017204058.GR5737@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
henk de wit escribió:
> > How is the memory consumed? How are you measuring it? I assume you
> > mean the postgres process that is running the query uses the memory.
> > If so, which tool(s) are you using and what's the output that shows it
> > being used?
>
> It's periodically measured and recorded by a script from which the relevant parts are:
>
> GET_VSZ="ps aux | grep $REQ_GREP | grep -v grep | grep -v $$ | awk '{print \$5}'
> | sort -n | tail -n1";
> GET_RSS="ps aux | grep $REQ_GREP | grep -v grep | grep -v $$ | awk '{print \$6}'
> | sort -n | tail -n1";
Huh, this seems really ugly, have you tried something like just
$ ps -o cmd:50,vsz,rss -C postmaster
CMD VSZ RSS
/pgsql/install/00head/bin/postmaster 51788 3992
postgres: writer process 51788 1060
postgres: wal writer process 51788 940
postgres: autovacuum launcher process 51924 1236
postgres: stats collector process 22256 896
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-17 23:28:42 | Re: Huge amount of memory consumed during transaction |
Previous Message | Chris Kratz | 2007-10-17 19:43:40 | Re: Incorrect estimates on columns |