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

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