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
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 |