In response to A.Bhattacharya@xxxxxxxxxxx : > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
