postgres writer process growing up too much

From: "Heiner Vega" <hvegat(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres writer process growing up too much
Date: 2007-12-14 17:43:24
Message-ID: 3cc49c940712140943m1060e109tb95bf5fb0d95d426@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi to everyone

I've been monitoring my postgres processes and I noticed that the resident
memory
size of the writer process is growing up too much.
Those are reports from top in a 24 hour interval:

YESTERDAY:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11706 postgres 17 0 157m 148m 146m S 0.0 3.9 3:23.41 postgres:
postgres BJ3 127.0.0.1(64648) idle
12174 postgres 16 0 157m 148m 146m S 0.0 3.9 3:17.58 postgres:
postgres BJ3 127.0.0.1(65367) idle
11495 postgres 16 0 157m 148m 146m S 5.7 3.9 7:51.98 postgres:
postgres BJ3 127.0.0.1(64603) idle
11908 postgres 16 0 156m 147m 146m S 5.7 3.9 7:35.84 postgres:
postgres BJ3 127.0.0.1(64947) idle
11419 postgres 15 0 155m 112m 112m S 0.0 3.0 0:00.49 postgres:
writer process

TODAY:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11706 postgres 17 0 157m 148m 146m S 0.0 3.9 7:37.16 postgres:
postgres BJ3 127.0.0.1(64648) idle
12174 postgres 17 0 157m 148m 146m S 0.0 3.9 7:40.10 postgres:
postgres BJ3 127.0.0.1(65367) idle
11495 postgres 16 0 157m 148m 146m S 6.3 3.9 17:46.99 postgres:
postgres BJ3 127.0.0.1(64603) idle
11908 postgres 16 0 156m 147m 146m S 5.7 3.9 17:29.31 postgres:
postgres BJ3 127.0.0.1(64947) idle
11419 postgres 15 0 155m 140m 139m S 0.0 3.7 0:01.09 postgres:
writer process

Any ideas why is this happening?
My postgres version is 8.1.3

Thanks a lot
--
Heiner Vega Thames

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-12-14 17:48:27 Re: postgres writer process growing up too much
Previous Message Richard Broersma Jr 2007-12-14 17:32:01 Re: mssql migration and boolean to integer problems