Re: Postgres eats all memory

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: "Bartels, Eric" <e(dot)bartels(at)customsoft(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres eats all memory
Date: 2008-08-13 12:41:27
Message-ID: 48A2D677.3020103@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2008-08-13 10:06, Bartels, Eric wrote:

> After a while the whole system memory is eaten up and every
> operation becomes very slow.

Show us:

- output of "free" command, when server gets slow.

- output of "ps v --sort=-size | head -10"

- output of "ps auxww | grep postgres"

- in terminal start "top", write "fp", enter, "Fp", enter; copy us upper
half of your terminal screen.

- what options did you change in postgresql.conf?

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-08-13 12:43:30 Re: Postgres eats all memory
Previous Message kinuthiA muchanE 2008-08-13 12:30:50 SQl Tutorial