Skip site navigation (1) Skip section navigation (2)

Re: How to troubleshoot high mem usage by postgres?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris <ctlajoie(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to troubleshoot high mem usage by postgres?
Date: 2010-02-28 16:42:39
Message-ID: 9487.1267375359@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Chris <ctlajoie(at)gmail(dot)com> writes:
> @Tom Lane:
> As I mentioned above I am not doing everything in a single
> transaction. However I do want to try your suggestion regarding
> getting a "memory context map". But I'm afraid I don't know how to do
> what you are describing. How can I set the ulimit of postmaster?

Depends on the script you are using to start the postmaster.  One way is
to call ulimit in the startup script right before it invokes the
postmaster.  However, if you have something like

	su - postgres -c "postmaster ..."

then I'd try putting it in the postgres user's ~/.profile or
~/.bash_profile instead; the su is likely to reset such things.

> And
> does the postmaster stderr output go to the postgres log file?

Also depends.  Look at the startup script and see where it redirects
postmaster's stderr to.  You might have to modify the script --- some
are known to send stderr to /dev/null :-(

Sorry to be so vague, but different packagers have different ideas
about how to do this.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2010-02-28 20:19:51
Subject: Estimation issue with partitioned tables
Previous:From: Greg SmithDate: 2010-02-28 05:06:36
Subject: Re: SSD + RAID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group