In response to A(dot)Bhattacharya(at)sungard(dot)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