Would turning autocommit off help?


Vivek Khera wrote:
"FW" == Florian Weimer <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
Cranel. Technology. Integrity. Focus.



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to