Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.

From: <A(dot)Bhattacharya(at)sungard(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date: 2009-12-11 06:55:57
Message-ID: 4AD2336877609F41A2B0D53BAD09FC57B6EE4A@VOO-EXCHANGE07.internal.sungard.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All.

I have a program which import some 6000-10000 records in Postgres
database. However the import of data is successful but the postgres.exe
almost takes up entire memory and CPU.

I could see in the process list there are lot of postgres.exe are
running and one of the postgres.exe has taken up 98% of CPU.Even
stopping the Postgres database service is not killing this processes
running so I have to kill them individual processes.

I have the below parameters set in Postgresql.conf file.

# - Memory -

shared_buffers = 512MB

work_mem = 256MB

# - Free Space Map -

max_fsm_pages = 500000

max_fsm_relations = 5000

Below is the autovacuum settings

autovacuum = on

log_autovacuum_min_duration = 0
.

autovacuum_max_workers = 20

autovacuum_naptime = 5min

autovacuum_vacuum_threshold = 50

autovacuum_analyze_threshold = 50

autovacuum_vacuum_scale_factor = 0.2

autovacuum_analyze_scale_factor = 0.1

autovacuum_freeze_max_age = 200000000

autovacuum_vacuum_cost_delay = 20

I am using Postgres 8.3.5 on windows XP environment 32-bit.

I would really appreciate any help on this as this is one of the show
stopper for us.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-12-11 07:15:11 Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Previous Message Pavel Stehule 2009-12-11 06:52:28 Re: PIVOT tables and crosstab