| 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: | Whole Thread | Raw Message | 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 |