Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date
Msg-id 20091211072140.GC11321@a-kretschmer.de
Whole thread Raw
In response to Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (<A.Bhattacharya@sungard.com>)
List pgsql-general
Tree view 
In response to A.Bhattacharya@sungard.com :
> Hi All.
>
>
>
> I have a program which import some 6000-10000 records in Postgres database.

How? With COPY or with INSERT? Within one single transaction or every
Insert in an own transaction?


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

Really bad idea...


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Next
From: "Massa, Harald Armin"
Date:
Subject: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.