Re: [PERFORM] Big question on insert performance/using COPY FROM

2005-09-01 Thread Richard Huxton
Morgan Kita wrote: Hi, I am currently trying to speed up the insertion of bulk loads to my database. I have fiddled with all of the parameters that I have seen suggested(aka checkpoint_segments, checkpoint_timeout, maintinence_work_mem, and shared buffers) with no success. I even turned off fysn

[PERFORM] Big question on insert performance/using COPY FROM

2005-08-31 Thread Morgan Kita
Hi, I am currently trying to speed up the insertion of bulk loads to my database. I have fiddled with all of the parameters that I have seen suggested(aka checkpoint_segments, checkpoint_timeout, maintinence_work_mem, and shared buffers) with no success. I even turned off fysnc with no effect s