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.