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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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