[Tile-serving] [osm2pgsql-dev/osm2pgsql] Disable synchronous commit on all connections (PR #2131)

[Jochen Topf]

This simplifies the code, because we don't have to decide whether to set this or not on each connection. And it doesn't matter much when setting this for read-only connections which don't need this.

Setting synchronous_commit = off speeds up writing to the database, because commis are not delayed until the WAL is written to disk. It can not lead to corruption of the database.

https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT
You can view, comment on, or merge this pull request online at:

  https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131

-- Commit Summary --

  * Disable synchronous commit on all connections

-- File Changes --

    M src/db-copy.cpp (3)
    M src/flex-table.cpp (1)
    M src/pgsql.cpp (5)
    M src/table.cpp (2)

-- Patch Links --

https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.patch
https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.diff

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/pull/2131 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240202/0b10a483/attachment.htm>