Re: Postgres is eating up all my memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Steinheuser <psteinheuser(at)myyearbook(dot)com>
Cc: ml ml <mliebherr99(at)googlemail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres is eating up all my memory
Date: 2009-08-14 13:59:24
Message-ID: 8312.1250258364@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Steinheuser <psteinheuser(at)myyearbook(dot)com> writes:
> Parameters like shared_buffers, work_mem are the ones you'll probably need
> to adjust.

> Work_mem is per user, and can actually be multiples per user, depending on
> what you're doing.

temp_buffers is per-process too --- if there's heavy use of temp tables
in this application, that could be the problem.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message OldManRiver 2009-08-14 14:49:02 Just Forgot
Previous Message Peter Steinheuser 2009-08-14 13:17:56 Re: Postgres is eating up all my memory