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