Re: Bulk INSERT performance in 7.4.1

Would turning autocommit off help?


Vivek Khera wrote:
>>>>>>"FW" == Florian Weimer <fw@deneb.enyo.de> writes:
>
>
> FW> After increasing the number of checkpoint segments and the shared-memory
> FW> buffers, performance is back to the expected levels.  It might even be a
> FW> bit faster.
>
> If you've got the time, could you try also doing the full bulk insert
> test with the checkpoint log files on another physical disk?  See if
> that's any faster.
>


--
Greg Spiegelberg
  Sr. Product Development Engineer
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@Cranel.com
Cranel. Technology. Integrity. Focus.