ChangesetMD icon indicating copy to clipboard operation
ChangesetMD copied to clipboard

Published 20 hours ago • verified publisher icon ToeBee

synchronous_commit

Open pnorman opened this issue 11 years ago • 2 comments

If the server with postgres crashes there is no way to restore an interrupted upload. It is therefore safe to use synchronous_commit, as the data is lost anyways.

synchronous_commit should be set to off, with SQL like SET synchronous_commit TO OFF;

pnorman avatar May 26 '13 07:05 pnorman

Will this actually get me anything though? Since I'm doing everything inside of a single huge transaction I don't think this would actually get me any kind of measurable performance boost.

ToeBee avatar May 30 '13 01:05 ToeBee

Not that I can see - you're creating a new cursor for each changeset and doing an INSERT at https://github.com/ToeBee/ChangesetMD/blob/master/changesetmd.py#L56

pnorman avatar May 30 '13 03:05 pnorman