Home > Archive > PostgreSQL Performance > March 2006 > Re: Migration study, step 1: bulk write









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Migration study, step 1: bulk write
Simon Riggs

2006-03-22, 7:33 am

On Wed, 2006-03-22 at 10:04 +0100, Mikael Carneholm wrote:
> but that gave a more uneven insert rate


Not sure what you mean, but happy to review test results.

You should be able to tweak other parameters from here as you had been
trying. Your bgwriter will be of some benefit now if you set it
aggressively enough to keep up.

Your thoughts on this process are welcome...

Best Regards, Simon Riggs


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com