From: | "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com> |
---|---|
To: | <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Insert into large table |
Date: | 2003-09-01 16:48:04 |
Message-ID: | 001401c370a8$d5479240$731932d2@athlon2000 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I am using version 7.3.1 on windows and am finding the insert/update performance on a particular large table is less than acceptable.
the table contains end of day share data and as such contain about 2000 entries for each day for the last 3 years.
At the end of each days trading I use the copy command to load the records into a temp table to check data validity then I use a insert into x ( ) select .... from temp
and wait and wait and wait.
My machine is a W2000 box with 256mb RAM and an Athlon 2000 processor so I expected a much faster result.
When I look in the task manager the postgres process is only using 2% to 6% of CPU time.
What things should I be checking to up the performance of the postgres DB?
thanks
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-09-01 19:15:08 | Re: ERROR: c: permission denied |
Previous Message | Leonardo Hantei | 2003-09-01 09:26:58 | Downloading ipc-daemon |